INV Mass Lot Attributes Sync

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Mass Lot Attributes Sync
Short Name: INVLTATT_XML
DB package: INV_INVLTATT_XMLP_PKG
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
Organization
 
Number
Commit Option
 
LOV Oracle
Sync Description Flexfield
 
LOV Oracle
Destination Organization To
 
LOV Oracle
Destination Organization From
 
LOV Oracle
Lot High
 
LOV Oracle
Lot Low
 
LOV Oracle
INV_SRS_ITEM_PAIR
 
Item Low
 
Source Organization
 
LOV Oracle