DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on MTL_SYSTEM_ITEMS

Line 828: , MTL_SYSTEM_ITEMS MSI

824: RD.DISTRIBUTION_ID
825: FROM PO_REQ_DISTRIBUTIONS_ALL RD
826: , PO_REQUISITION_LINES_ALL RL
827: , PJM_ORG_PARAMETERS POP
828: , MTL_SYSTEM_ITEMS MSI
829: , MTL_UNITS_OF_MEASURE_VL UOM
830: WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY'
831: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
832: AND RD.PROJECT_ID IS NULL

Line 897: , MTL_SYSTEM_ITEMS MSI

893: RL.LINE_NUM,
894: RD.DISTRIBUTION_ID
895: FROM PO_REQ_DISTRIBUTIONS_ALL RD
896: , PO_REQUISITION_LINES_ALL RL
897: , MTL_SYSTEM_ITEMS MSI
898: , MTL_UNITS_OF_MEASURE_VL UOM
899: WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY'
900: AND RD.PROJECT_ID = p_ProjectID
901: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID

Line 1058: , MTL_SYSTEM_ITEMS MSI

1054: POD.PO_DISTRIBUTION_ID
1055: FROM PO_DISTRIBUTIONS_ALL POD
1056: , PO_LINES_ALL POL
1057: , PJM_ORG_PARAMETERS POP
1058: , MTL_SYSTEM_ITEMS MSI
1059: , MTL_UNITS_OF_MEASURE_VL UOM
1060: WHERE POD.DESTINATION_TYPE_CODE = 'INVENTORY'
1061: AND POL.PO_LINE_ID = POD.PO_LINE_ID
1062: AND POD.PROJECT_ID IS NULL

Line 1127: , MTL_SYSTEM_ITEMS MSI

1123: POL.LINE_NUM,
1124: POD.PO_DISTRIBUTION_ID
1125: FROM PO_DISTRIBUTIONS_ALL POD
1126: , PO_LINES_ALL POL
1127: , MTL_SYSTEM_ITEMS MSI
1128: , MTL_UNITS_OF_MEASURE_VL UOM
1129: WHERE POD.DESTINATION_TYPE_CODE = 'INVENTORY'
1130: AND POD.PROJECT_ID = p_ProjectID
1131: AND POL.PO_LINE_ID = POD.PO_LINE_ID