APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on WIP_CONSTANTS

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

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

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

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

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

940: CLOSE get_mtl_txn_csr;
941:
942: --If return material transaction, fetch all matching disp for wo, mtl_txn
943: -- and disposition item with txn item.
944: IF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
945: i:=0;
946: --dbms_output.put_line('Transaction is Return type i= ' || i);
947: OPEN get_disp_return_csr(p_wo_mtl_txn_id, l_txn_rec.workorder_id,
948: l_txn_rec.trackable_flag,

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

982: x_disp_list_tbl(i):= l_disp_assoc_rec;
983: i:=i+1;
984: END LOOP;
985: CLOSE get_disp_return_csr;
986: ELSIF (l_txn_rec.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
987: i:=0;
988: OPEN get_disp_issue_csr(p_wo_mtl_txn_id, l_txn_rec.workorder_id,
989: l_txn_rec.trackable_flag);
990: LOOP

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

1070: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,
1071: AHL_WORKORDER_MTL_TXNS mtxn
1072: WHERE disp.disposition_id = p_disp_id
1073: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1074: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)
1075: AND disp.disposition_id = assoc.disposition_id
1076: GROUP BY disp.disposition_id, assoc.disposition_id;
1077: --
1078: l_txn_qty NUMBER :=0;

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

1111: AHL_WORKORDER_MTL_TXNS mtxn
1112: WHERE disp.disposition_id = p_disp_id
1113: AND assoc.workorder_mtl_txn_id = p_workorder_txn_id
1114: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1115: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)
1116: AND disp.disposition_id = assoc.disposition_id
1117: GROUP BY disp.disposition_id, assoc.disposition_id;
1118: --
1119: l_txn_qty NUMBER :=0;