DBA Data[Home] [Help]

APPS.CSL_MTL_TRANS_LOT_NUM_ACC_PKG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 28: FROM MTL_TRANSACTION_LOT_NUMBERS

24: b_inventory_item_id NUMBER,
25: b_organization_id NUMBER
26: ) IS
27: SELECT TRANSACTION_ID, LOT_NUMBER
28: FROM MTL_TRANSACTION_LOT_NUMBERS
29: WHERE TRANSACTION_ID = b_transaction_id
30: AND INVENTORY_ITEM_ID = b_inventory_item_id
31: AND ORGANIZATION_ID = b_organization_id;
32:

Line 105: FROM MTL_TRANSACTION_LOT_NUMBERS

101: b_inventory_item_id NUMBER,
102: b_organization_id NUMBER
103: ) IS
104: SELECT TRANSACTION_ID, LOT_NUMBER
105: FROM MTL_TRANSACTION_LOT_NUMBERS
106: WHERE TRANSACTION_ID = b_transaction_id
107: AND INVENTORY_ITEM_ID = b_inventory_item_id
108: AND ORGANIZATION_ID = b_organization_id;
109:

Line 218: FROM MTL_TRANSACTION_LOT_NUMBERS

214: b_inventory_item_id NUMBER,
215: b_organization_id NUMBER
216: ) IS
217: SELECT TRANSACTION_ID, LOT_NUMBER
218: FROM MTL_TRANSACTION_LOT_NUMBERS
219: WHERE TRANSACTION_ID = b_transaction_id
220: AND INVENTORY_ITEM_ID = b_inventory_item_id
221: AND ORGANIZATION_ID = b_organization_id;
222: