DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PO_DISTRIBUTIONS_ALL

Line 269: PO_DISTRIBUTIONS_ALL POD

265: WHERE EXISTS
266: (
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 */

Line 361: , PO_DISTRIBUTIONS_ALL POD

357: , PER_ALL_PEOPLE_F REQ
358: , HR_ALL_ORGANIZATION_UNITS O
359: , PA_EXPENDITURE_TYPES ET
360: , PA_TASKS T
361: , PO_DISTRIBUTIONS_ALL POD
362: , PA_PROJECTS P
363: , GL_LEDGERS G /* Added for bug 3537697 */
364: WHERE
365: /* POH.VENDOR_ID = V.VENDOR_ID (+) Removed join for bug 1751445 */

Line 1055: FROM PO_DISTRIBUTIONS_ALL POD

1051: FROM (
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

Line 1073: FROM PO_DISTRIBUTIONS_ALL POD

1069: UNION ALL
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

Line 1125: FROM PO_DISTRIBUTIONS_ALL POD

1121: FROM (
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'

Line 1139: FROM PO_DISTRIBUTIONS_ALL POD

1135: UNION ALL
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

Line 1201: , PO_DISTRIBUTIONS_ALL POD

1197: FROM
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