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
Description: Lot attributes update report
Application: Inventory
Source: Mass Lot Attributes Sync
Short Name: INVLTATT_XML
DB package: INV_INVLTATT_XMLP_PKG
Run
INV Mass Lot Attributes Sync and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |