APPS.INV_INVLTATT_XMLP_PKG dependencies on MTL_LOTATT_SYNC_REPORT_TEMP

Line 20: DELETE MTL_LOTATT_SYNC_REPORT_TEMP WHERE group_id=P_CONC_REQUEST_ID;

16:
17: FUNCTION AFTERREPORT RETURN BOOLEAN IS
18: BEGIN
19: BEGIN
20: DELETE MTL_LOTATT_SYNC_REPORT_TEMP WHERE group_id=P_CONC_REQUEST_ID;
21: END;
22: RETURN (TRUE);
23: END AFTERREPORT;
24:

Line 66: INSERT INTO MTL_LOTATT_SYNC_REPORT_TEMP

62: PROCEDURE POPULATE_SYNC_REPORT_TMP IS
63: BEGIN
64: --starting insert into the synchornized tmp table
65: --populate the lot numbers from source organization
66: INSERT INTO MTL_LOTATT_SYNC_REPORT_TEMP
67: (organization_id,
68: inventory_item_id,
69: group_id,
70: lot_number,

Line 244: INSERT INTO MTL_LOTATT_SYNC_REPORT_TEMP

240: where mr.organization_id = mln.organization_id
241: and mr.inventory_item_id = mln.inventory_item_id
242: and mr.lot_number = mln.lot_number);
243: --populate the lot numbers from dest organization
244: INSERT INTO MTL_LOTATT_SYNC_REPORT_TEMP
245: (organization_id,
246: inventory_item_id,
247: group_id,
248: lot_number,