APPS.RMA_UPDATE dependencies on MTL_SO_RMA_RECEIPTS

Line 13: INSERT INTO mtl_so_rma_receipts(

9: DELETE FROM mtl_material_transactions_temp
10: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
11:
12:
13: INSERT INTO mtl_so_rma_receipts(
14: RMA_RECEIPT_ID,RMA_INTERFACE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID,RECEIVED_QUANTITY,ACCEPTED_QUANTITY,UNIT_CODE,
15: RECEIPT_DATE,RETURN_SUBINVENTORY_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY)
16: SELECT
17: mt.transaction_temp_id,mt.trx_source_delivery_id,mt.organization_id,

Line 71: INSERT INTO mtl_so_rma_receipts(

67:
68: DELETE FROM mtl_material_transactions_temp
69: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
70:
71: INSERT INTO mtl_so_rma_receipts(
72: RMA_RECEIPT_ID,RMA_INTERFACE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID,RECEIVED_QUANTITY,ACCEPTED_QUANTITY,UNIT_CODE,
73: RECEIPT_DATE,RETURN_SUBINVENTORY_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY)
74: SELECT
75: mt.transaction_id,mt.trx_source_delivery_id,mt.organization_id,mt.inventory_item_id,

Line 132: INSERT INTO mtl_so_rma_receipts(

128: DELETE FROM mtl_material_transactions_temp
129: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
130:
131:
132: INSERT INTO mtl_so_rma_receipts(
133: RMA_RECEIPT_ID,RMA_INTERFACE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID,RECEIVED_QUANTITY,ACCEPTED_QUANTITY,UNIT_CODE,
134: RECEIPT_DATE,RETURN_SUBINVENTORY_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY)
135: SELECT
136: mt.transaction_temp_id,mt.trx_source_delivery_id,mt.organization_id,mt.inventory_item_id, mt.department_id * -1,

Line 178: INSERT INTO mtl_so_rma_receipts(

174: DELETE FROM mtl_material_transactions_temp
175: WHERE transaction_header_id = header_id_value AND process_flag = 'N' ;
176:
177:
178: INSERT INTO mtl_so_rma_receipts(
179: RMA_RECEIPT_ID,RMA_INTERFACE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID,RECEIVED_QUANTITY,ACCEPTED_QUANTITY,UNIT_CODE,
180: RECEIPT_DATE,RETURN_SUBINVENTORY_NAME,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY)
181: SELECT
182: mt.transaction_id,mt.trx_source_delivery_id,mt.organization_id,mt.inventory_item_id, mt.department_id * -1,