INV Mass Lot Attributes Sync

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Lot attributes update report
Application: Inventory
Source: Mass Lot Attributes Sync
Short Name: INVLTATT_XML
DB package: INV_INVLTATT_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, MSIB.ORGANIZATION_ID, MSIB.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE,
       T1.INVENTORY_ITEM_ID,
       T1.LOT_NUMBER,
       T1.ORGANIZATION_ID SRC_ORG_ID,
       MP1.ORGANIZATION_CODE SRC_ORG,
       T1.GRADE_CODE SRC_GRADE_CODE,
       T1.ORIGINATION_DATE SRC_ORIGINATION_DATE,
       T1.EXPIRATION_DATE SRC_EXP_DATE,
       T1.MATURITY_DATE SRC_MATURITY_DATE,
       T1.EXPIRATION_ACTION_DATE SRC_EXP_ACTION_DATE,
       T1.EXPIRATION_ACTION_CODE SRC_EXP_ACTION_CODE,
       T1.HOLD_DATE SRC_HOLD_DATE,
       T1.RETEST_DATE SRC_RETEST_DATE,
       T1.ATTRIBUTE_CATEGORY SRC_ATTCG,
       T1.ATTRIBUTE1 SRC_ATT1,
       T1.ATTRIBUTE2 SRC_ATT2,
       T1.ATTRIBUTE3 SRC_ATT3,
       T1.ATTRIBUTE4 SRC_ATT4,
       T1.ATTRIBUTE5 SRC_ATT5,
       T1.ATTRIBUTE6 SRC_ATT6,
       T1.ATTRIBUTE7 SRC_ATT7,
       T1.ATTRIBUTE8 SRC_ATT8,
       T1.ATTRIBUTE9 SRC_ATT9,
       T1.ATTRIBUTE10 SRC_ATT10,
       T1.ATTRIBUTE11 SRC_ATT11,
       T1.ATTRIBUTE12 SRC_ATT12,
       T1.ATTRIBUTE13 SRC_ATT13,
       T1.ATTRIBUTE14 SRC_ATT14,
       T1.ATTRIBUTE15 SRC_ATT15,
       T1.C_ATTRIBUTE1 SRC_C_ATT1,
       T1.C_ATTRIBUTE2 SRC_C_ATT2,
       T1.C_ATTRIBUTE3 SRC_C_ATT3,
       T1.C_ATTRIBUTE4 SRC_C_ATT4,
       T1.C_ATTRIBUTE5 SRC_C_ATT5,
       T1.C_ATTRIBUTE6 SRC_C_ATT6,
       T1.C_ATTRIBUTE7 SRC_C_ATT7,
       T1.C_ATTRIBUTE8 SRC_C_ATT8,
       T1.C_ATTRIBUTE9 SRC_C_ATT9,
       T1.C_ATTRIBUTE10 SRC_C_ATT10,
       T1.C_ATTRIBUTE11 SRC_C_ATT11,
       T1.C_ATTRIBUTE12 SRC_C_ATT12,
       T1.C_ATTRIBUTE13 SRC_C_ATT13,
       T1.C_ATTRIBUTE14 SRC_C_ATT14,
       T1.C_ATTRIBUTE15 SRC_C_ATT15,
       T1.C_ATTRIBUTE16 SRC_C_ATT16,
       T1.C_ATTRIBUTE17 SRC_C_ATT17,
       T1.C_ATTRIBUTE18 SRC_C_ATT18,
       T1.C_ATTRIBUTE19 SRC_C_ATT19,
       T1.C_ATTRIBUTE20 SRC_C_ATT20,
       T1.D_ATTRIBUTE1 SRC_D_ATT1,
       T1.D_ATTRIBUTE2 SRC_D_ATT2,
       T1.D_ATTRIBUTE3 SRC_D_ATT3,
       T1.D_ATTRIBUTE4 SRC_D_ATT4,
       T1.D_ATTRIBUTE5 SRC_D_ATT5,
       T1.D_ATTRIBUTE6 SRC_D_ATT6,
       T1.D_ATTRIBUTE7 SRC_D_ATT7,
       T1.D_ATTRIBUTE8 SRC_D_ATT8,
       T1.D_ATTRIBUTE9 SRC_D_ATT9,
       T1.D_ATTRIBUTE10 SRC_D_ATT10,
       T1.N_ATTRIBUTE1 SRC_N_ATT1,
       T1.N_ATTRIBUTE2 SRC_N_ATT2,
       T1.N_ATTRIBUTE3 SRC_N_ATT3,
       T1.N_ATTRIBUTE4 SRC_N_ATT4,
       T1.N_ATTRIBUTE5 SRC_N_ATT5,
       T1.N_ATTRIBUTE6 SRC_N_ATT6,
       T1.N_ATTRIBUTE7 SRC_N_ATT7,
       T1.N_ATTRIBUTE8 SRC_N_ATT8,
       T1.N_ATTRIBUTE9 SRC_N_ATT9,
       T1.N_ATTRIBUTE10 SRC_N_ATT10,
       T2.ORGANIZATION_ID DEST_ORG_ID,
       MP2.ORGANIZATION_CODE DEST_ORG,
       T2.GRADE_CODE DEST_GRADE_CODE,
       T2.ORIGINATION_DATE DEST_ORIGINATION_DATE,
       T2.EXPIRATION_DATE DEST_EXP_DATE,
       T2.MATURITY_DATE DEST_MATURITY_DATE,
       T2.EXPIRATION_ACTION_DATE DEST_EXP_ACTION_DATE,
       T2.EXPIRATION_ACTION_CODE DEST_EXP_ACTION_CODE,
       T2.HOLD_DATE DEST_HOLD_DATE,
       T2.RETEST_DATE DEST_RETEST_DATE,
       T2.ATTRIBUTE_CATEGORY DEST_ATTCG,
       T2.ATTRIBUTE1 DEST_ATT1,
       T2.ATTRIBUTE2 DEST_ATT2,
       T2.ATTRIBUTE3 DEST_ATT3,
       T2.ATTRIBUTE4 DEST_ATT4,
       T2.ATTRIBUTE5 DEST_ATT5,
       T2.ATTRIBUTE6 DEST_ATT6,
       T2.ATTRIBUTE7 DEST_ATT7,
       T2.ATTRIBUTE8 DEST_ATT8,
       T2.ATTRIBUTE9 DEST_ATT9,
       T2.ATTRIBUTE10 DEST_ATT10,
       T2.ATTRIBUTE11 DEST_ATT11,
       T2.ATTRIBUTE12 DEST_ATT12,
       T2.ATTRIBUTE13 DEST_ATT13,
       T2.ATTRIBUTE14 DEST_ATT14,
       T2.ATTRIBUTE15 DEST_ATT15,
       T2.C_ATTRIBUTE1 DEST_C_ATT1,
       T2.C_ATTRIBUTE2 DEST_C_ATT2,
       T2.C_ATTRIBUTE3 DEST_C_ATT3,
       T2.C_ATTRIBUTE4 DEST_C_ATT4,
       T2.C_ATTRIBUTE5 DEST_C_ATT5,
       T2.C_ATTRIBUTE6 DEST_C_ATT6,
       T2.C_ATTRIBUTE7 DEST_C_ATT7,
       T2.C_ATTRIBUTE8 DEST_C_ATT8,
       T2.C_ATTRIBUTE9 DEST_C_ATT9,
       T2.C_ATTRIBUTE10 DEST_C_ATT10,
       T2.C_ATTRIBUTE11 DEST_C_ATT11,
       T2.C_ATTRIBUTE12 DEST_C_ATT12,
       T2.C_ATTRIBUTE13 DEST_C_ATT13,
       T2.C_ATTRIBUTE14 DEST_C_ATT14,
       T2.C_ATTRIBUTE15 DEST_C_ATT15,
       T2.C_ATTRIBUTE16 DEST_C_ATT16,
       T2.C_ATTRIBUTE17 DEST_C_ATT17,
       T2.C_ATTRIBUTE18 DEST_C_ATT18,
       T2.C_ATTRIBUTE19 DEST_C_ATT19,
       T2.C_ATTRIBUTE20 DEST_C_ATT20,
       T2.D_ATTRIBUTE1 DEST_D_ATT1,
       T2.D_ATTRIBUTE2 DEST_D_ATT2,
       T2.D_ATTRIBUTE3 DEST_D_ATT3,
       T2.D_ATTRIBUTE4 DEST_D_ATT4,
       T2.D_ATTRIBUTE5 DEST_D_ATT5,
       T2.D_ATTRIBUTE6 DEST_D_ATT6,
       T2.D_ATTRIBUTE7 DEST_D_ATT7,
       T2.D_ATTRIBUTE8 DEST_D_ATT8,
       T2.D_ATTRIBUTE9 DEST_D_ATT9,
       T2.D_ATTRIBUTE10 DEST_D_ATT10,
       T2.N_ATTRIBUTE1 DEST_N_ATT1,
       T2.N_ATTRIBUTE2 DEST_N_ATT2,
       T2.N_ATTRIBUTE3 DEST_N_ATT3,
       T2.N_ATTRIBUTE4 DEST_N_ATT4,
       T2.N_ATTRIBUTE5 DEST_N_ATT5,
       T2.N_ATTRIBUTE6 DEST_N_ATT6,
       T2.N_ATTRIBUTE7 DEST_N_ATT7,
       T2.N_ATTRIBUTE8 DEST_N_ATT8,
       T2.N_ATTRIBUTE9 DEST_N_ATT9,
       T2.N_ATTRIBUTE10 DEST_N_ATT10
FROM MTL_LOTATT_SYNC_REPORT_TEMP T1,
     MTL_LOTATT_SYNC_REPORT_TEMP T2,
     MTL_SYSTEM_ITEMS_B MSIB,
     MTL_PARAMETERS MP1,
     MTL_PARAMETERS MP2
WHERE T1.INVENTORY_ITEM_ID=T2.INVENTORY_ITEM_ID
AND T1.LOT_NUMBER = T2.LOT_NUMBER
AND T1.FLAG=1 AND T2.FLAG=2
AND MSIB.INVENTORY_ITEM_ID = T1.INVENTORY_ITEM_ID
AND MSIB.organization_id = t1.organization_id
AND T1.organization_id = MP1.organization_id
AND T2.organization_id = MP2.organization_id
AND T1.group_id = :P_CONC_REQUEST_ID
AND T2.group_id = :P_CONC_REQUEST_ID
Parameter Name SQL text Validation
Source Organization
 
LOV Oracle
Item Low
 
Char
INV_SRS_ITEM_PAIR
 
Char
Lot Low
 
LOV Oracle
Lot High
 
LOV Oracle
Destination Organization From
 
LOV Oracle
Destination Organization To
 
LOV Oracle
Sync Description Flexfield
 
LOV Oracle
Commit Option
 
LOV Oracle