DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PO_LINES_ALL

Line 271: , PO_LINES_ALL POL

267: SELECT /*+ leading(pod) */ '1' --bug 6872563 - skkoppul : Added hint
268: FROM
269: PO_DISTRIBUTIONS_ALL POD
270: , PO_HEADERS_ALL POH
271: , PO_LINES_ALL POL
272: , PO_RELEASES_ALL POR
273: , PO_DOCUMENT_TYPES_TL PDT --/* added for bug 6367516 */
274: , PO_LINE_LOCATIONS_ALL PLL
275: /* , PER_ALL_PEOPLE_F BUY

Line 353: , PO_LINES_ALL POL

349: PO_HEADERS_ALL POH
350: , PO_RELEASES_ALL POR
351: , PO_DOCUMENT_TYPES PDT
352: /* , PO_VENDORS V Removed for bug 1751445 */
353: , PO_LINES_ALL POL
354: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */
355: , PO_LINE_LOCATIONS_ALL PLL
356: , PER_ALL_PEOPLE_F BUY
357: , PER_ALL_PEOPLE_F REQ

Line 1056: , PO_LINES_ALL POL

1052: SELECT POL.PO_HEADER_ID,
1053: POL.LINE_NUM,
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'

Line 1074: , PO_LINES_ALL POL

1070: SELECT POL.PO_HEADER_ID,
1071: POL.LINE_NUM,
1072: POD.PO_DISTRIBUTION_ID
1073: FROM PO_DISTRIBUTIONS_ALL POD
1074: , PO_LINES_ALL POL
1075: , PJM_ORG_PARAMETERS POP
1076: , WIP_DISCRETE_JOBS WDJ
1077: , WIP_OPERATIONS WO
1078: , BOM_DEPARTMENTS BD

Line 1126: , PO_LINES_ALL POL

1122: SELECT POL.PO_HEADER_ID,
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

Line 1140: , PO_LINES_ALL POL

1136: SELECT POL.PO_HEADER_ID,
1137: POL.LINE_NUM,
1138: POD.PO_DISTRIBUTION_ID
1139: FROM PO_DISTRIBUTIONS_ALL POD
1140: , PO_LINES_ALL POL
1141: , WIP_DISCRETE_JOBS WDJ
1142: , WIP_OPERATIONS WO
1143: , BOM_DEPARTMENTS BD
1144: , MTL_UNITS_OF_MEASURE_VL UOM

Line 1202: , PO_LINES_ALL POL

1198: PJM_PO_COMMITMENTS_V PJPO
1199: , PO_HEADERS_ALL POH
1200: , PO_LINE_LOCATIONS_ALL PLL
1201: , PO_DISTRIBUTIONS_ALL POD
1202: , PO_LINES_ALL POL
1203: , GL_LEDGERS G
1204: WHERE PJPO.PROJECT_ID = p_ProjectID
1205: AND PJPO.PO_Header_ID = POH.PO_Header_ID
1206: AND POL.PO_Header_ID = POH.PO_Header_ID