APPS.WIP_OVERCOMPLETION dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 145: mtl_material_transactions_temp mmtt1,

141: Decode(p_appl_id,-1,NULL,p_appl_id),
142: Decode(p_prog_id,-1,NULL,p_prog_id),
143: Decode(p_req_id,-1,NULL,Sysdate)
144: FROM wip_requirement_operations wro1,
145: mtl_material_transactions_temp mmtt1,
146: mtl_material_txn_allocations mmta1
147: WHERE
148: wro1.ROWID = wro.ROWID
149: -- The WO rows to be updated are identified by the rowids.

Line 165: mtl_material_transactions_temp mmtt2,

161: WHERE wro.ROWID IN
162: (
163: SELECT wro2.ROWID FROM
164: wip_requirement_operations wro2,
165: mtl_material_transactions_temp mmtt2,
166: mtl_material_txn_allocations mmta2
167: WHERE
168: mmtt2.transaction_action_id = wip_constants.cplassy_action
169: AND mmtt2.overcompletion_primary_qty IS NOT NULL

Line 924: FROM mtl_material_transactions_temp

920: MIN(repetitive_line_id),
921: MIN(operation_seq_num)
922: INTO x_org_id, x_wip_entity_id, x_line_id,
923: x_last_operation_seq_num
924: FROM mtl_material_transactions_temp
925: WHERE completion_transaction_id = p_parent_cpl_txn_id
926: AND transaction_action_id = wip_constants.cplassy_action;
927:
928: IF( x_result = wip_constants.no ) THEN

Line 1128: from mtl_material_transactions_temp mmtt,

1124: NULL, /* qa_collection_id, */
1125: p_oc_txn_id, /* overcompletion_transaction_id */
1126: NULL, /* overcompletion_transaction_qty */
1127: NULL /* overcompletion_primary_qty */
1128: from mtl_material_transactions_temp mmtt,
1129: mtl_system_items msi
1130: where
1131: mmtt.completion_transaction_id = p_parent_cpl_txn_id
1132: and mmtt.transaction_action_id = wip_constants.cplassy_action