APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on WIP_CONSTANTS

Line 191: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE ) OR

187: CLOSE get_mtl_txn_rec_csr;
188:
189: --Validate that disposition item and mtl txn item are equal for matching types.
190: IF (((l_disp_rec.immediate_disposition_code <> 'NOT_RECEIVED' AND
191: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE ) OR
192: (l_disp_rec.immediate_disposition_code = 'NOT_RECEIVED' AND
193: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE))
194: AND (l_disp_rec.inventory_item_id <> l_mtl_txn_rec.inventory_item_id)) THEN
195: -- (Jay found this problem) The organization_id in disposition entity maps to instance's last_vld_org_id

Line 193: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE))

189: --Validate that disposition item and mtl txn item are equal for matching types.
190: IF (((l_disp_rec.immediate_disposition_code <> 'NOT_RECEIVED' AND
191: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE ) OR
192: (l_disp_rec.immediate_disposition_code = 'NOT_RECEIVED' AND
193: l_mtl_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE))
194: AND (l_disp_rec.inventory_item_id <> l_mtl_txn_rec.inventory_item_id)) THEN
195: -- (Jay found this problem) The organization_id in disposition entity maps to instance's last_vld_org_id
196: -- if the instance_id is not null. Thus it could be different from job's org which equals to material
197: -- transaction organization.

Line 956: IF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

952: CLOSE get_mtl_txn_csr;
953:
954: --If return material transaction, fetch all matching disp for wo, mtl_txn
955: -- and disposition item with txn item.
956: IF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
957: i:=0;
958: --dbms_output.put_line('Transaction is Return type i= ' || i);
959: OPEN get_disp_return_csr(p_wo_mtl_txn_id, l_txn_rec.workorder_id,
960: l_txn_rec.trackable_flag,

Line 998: ELSIF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

994: x_disp_list_tbl(i):= l_disp_assoc_rec;
995: i:=i+1;
996: END LOOP;
997: CLOSE get_disp_return_csr;
998: ELSIF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
999: i:=0;
1000: OPEN get_disp_issue_csr(p_wo_mtl_txn_id, l_txn_rec.workorder_id,
1001: l_txn_rec.trackable_flag);
1002: LOOP

Line 1086: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)

1082: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,
1083: AHL_WORKORDER_MTL_TXNS mtxn
1084: WHERE disp.disposition_id = p_disp_id
1085: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1086: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)
1087: AND disp.disposition_id = assoc.disposition_id
1088: GROUP BY disp.disposition_id, assoc.disposition_id;
1089: --
1090: l_txn_qty NUMBER :=0;

Line 1127: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)

1123: AHL_WORKORDER_MTL_TXNS mtxn
1124: WHERE disp.disposition_id = p_disp_id
1125: AND assoc.workorder_mtl_txn_id = p_workorder_txn_id
1126: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1127: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)
1128: AND disp.disposition_id = assoc.disposition_id
1129: GROUP BY disp.disposition_id, assoc.disposition_id;
1130: --
1131: l_txn_qty NUMBER :=0;