APPS.PA_CHECK_COMMITMENTS dependencies on PO_DISTRIBUTIONS

Line 223: , PO_DISTRIBUTIONS POD

219: WHERE EXISTS (
220: SELECT '1'
221: FROM
222: AP_INVOICES_ALL I /* Changed for the bug #1530740 */
223: , PO_DISTRIBUTIONS POD
224: , AP_INVOICE_DISTRIBUTIONS_ALL D /* Changed for the bug #1530740 */
225: WHERE
226: I.Invoice_ID = D.Invoice_ID
227: AND NVL(POD.Distribution_type, 'XX') <> 'PREPAYMENT'

Line 254: Checks the PO distributions' tables against PA_Commitment_Txns

250: v_tmp := 'N';
251: End; -- Third Block, for new AP Invoices
252:
253: /* Fourth Block: NEW POs
254: Checks the PO distributions' tables against PA_Commitment_Txns
255: for new POs
256: */
257:
258: v_tmp := 'N';

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 325: Checks the PO distributions' tables against PA_Commitment_Txns

321: End; -- Fourth Block, for new POs
322:
323:
324: /* Fifth Block: UPDATED POs
325: Checks the PO distributions' tables against PA_Commitment_Txns
326: for updated POs
327: Note: For POs, all amounts are captured in Oracle Purchasing as denom amounts.
328: */
329:

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 502: , PO_DISTRIBUTIONS PO

498: , HR_ALL_ORGANIZATION_UNITS O
499: , PA_EXPEND_TYP_SYS_LINKS ES
500: , PA_EXPENDITURE_TYPES ET
501: , PA_TASKS T
502: , PO_DISTRIBUTIONS PO
503: , PA_PROJECTS P
504: WHERE
505: I.vendor_id = V.vendor_id
506: AND I.invoice_id = D.invoice_id

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