APPS.PA_CHECK_COMMITMENTS dependencies on PA_CMT_UTILS

Line 422: and nvl(CMT.denom_raw_cost,0) = GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(pod.po_distribution_id,

418: and CMT.original_quantity_ordered = POD.quantity_ordered
419: and NVL(CMT.quantity_cancelled,0) = NVL(POD.quantity_cancelled,0)
420: and NVL(CMT.quantity_delivered,0) = NVL(POD.quantity_delivered,0)
421: and CMT.quantity_invoiced = NVL(POD.quantity_billed,0)
422: and nvl(CMT.denom_raw_cost,0) = GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(pod.po_distribution_id,
423: POD.QUANTITY_ORDERED,
424: NVL(POD.QUANTITY_CANCELLED,0),
425: NVL(POD.QUANTITY_BILLED,0),'PO',
426: pol.po_line_id,

Line 444: , GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(pod.po_distribution_id,

440: , POD.expenditure_item_date
441: , POD.expenditure_type
442: , O.organization_id
443: , 'C'
444: , GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(pod.po_distribution_id,
445: POD.QUANTITY_ORDERED,
446: NVL(POD.QUANTITY_CANCELLED,0),
447: NVL(POD.QUANTITY_BILLED,0),'PO',
448: pol.po_line_id,

Line 1234: AND nvl(CMT.denom_raw_cost,0) = GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(PJPO.po_distribution_id,

1230: AND NVL(CMT.quantity_cancelled,0) = NVL(PJPO.quantity_cancelled,0)
1231: AND NVL(CMT.quantity_delivered,0) = NVL(PJPO.quantity_delivered,0)
1232: AND CMT.quantity_invoiced = NVL(PJPO.quantity_invoiced,0)
1233: AND G.LEDGER_ID = POD.SET_OF_BOOKS_ID
1234: AND nvl(CMT.denom_raw_cost,0) = GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(PJPO.po_distribution_id,
1235: PJPO.QUANTITY_ORDERED,
1236: NVL(PJPO.QUANTITY_CANCELLED,0),
1237: NVL(PJPO.QUANTITY_INVOICED,0),'PO',
1238: PJPO.po_line_id,

Line 1252: , GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(PJPO.po_distribution_id,

1248: , PJPO.expenditure_item_date
1249: , PJPO.expenditure_type
1250: , PJPO.expenditure_organization_id
1251: , 'C'
1252: , GREATEST(0,(PA_CMT_UTILS.get_rcpt_qty(PJPO.po_distribution_id,
1253: PJPO.QUANTITY_ORDERED,
1254: NVL(PJPO.QUANTITY_CANCELLED,0),
1255: NVL(PJPO.QUANTITY_INVOICED,0),'PO',
1256: PJPO.po_line_id,