eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_DISTRIBUTIONS

Line 899: FROM PO_DISTRIBUTIONS_ALL POD2

895: DECODE(
896: poll.matching_basis,
897: 'AMOUNT',
898: (SELECT sum(POD2.amount_ordered)
899: FROM PO_DISTRIBUTIONS_ALL POD2
900: WHERE POD2.line_location_id = poll.line_location_id ),
901: (SELECT sum(POD2.quantity_ordered)
902: FROM PO_DISTRIBUTIONS_ALL POD2
903: WHERE POD2.line_location_id = poll.line_location_id )),

Line 902: FROM PO_DISTRIBUTIONS_ALL POD2

898: (SELECT sum(POD2.amount_ordered)
899: FROM PO_DISTRIBUTIONS_ALL POD2
900: WHERE POD2.line_location_id = poll.line_location_id ),
901: (SELECT sum(POD2.quantity_ordered)
902: FROM PO_DISTRIBUTIONS_ALL POD2
903: WHERE POD2.line_location_id = poll.line_location_id )),
904: 'DOC_NUM',
905: gt.char6
906: ),

Line 920: FROM PO_DISTRIBUTIONS_ALL POD2

916: AND poll.po_line_id = pol.po_line_id
917: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
918: AND ((POLL.quantity IS NOT null
919: AND POLL.quantity <> (SELECT sum(POD2.quantity_ordered)
920: FROM PO_DISTRIBUTIONS_ALL POD2
921: WHERE POD2.line_location_id = poll.line_location_id ))
922: OR
923: (POLL.amount IS NOT null
924: AND POLL.amount <> (SELECT sum(POD2.amount_ordered)

Line 925: FROM PO_DISTRIBUTIONS_ALL POD2

921: WHERE POD2.line_location_id = poll.line_location_id ))
922: OR
923: (POLL.amount IS NOT null
924: AND POLL.amount <> (SELECT sum(POD2.amount_ordered)
925: FROM PO_DISTRIBUTIONS_ALL POD2
926: WHERE POD2.line_location_id = poll.line_location_id )))
927: );
928:
929:

Line 1254: po_distributions_all pod,

1250: ),
1251: gt.num1,
1252: gt.char3
1253: FROM
1254: po_distributions_all pod,
1255: po_line_locations poll,
1256: po_lines pol ,
1257: po_session_gt gt
1258: WHERE

Line 1429: po_distributions pod,

1425: ),
1426: gt.num1,
1427: gt.char3
1428: FROM
1429: po_distributions pod,
1430: po_line_locations poll,
1431: po_lines pol,
1432: po_session_gt gt
1433: WHERE

Line 1616: po_distributions pod,

1612: ),
1613: gt.num1,
1614: gt.char3
1615: FROM
1616: po_distributions pod,
1617: po_line_locations poll,
1618: po_lines pol,
1619: po_session_gt gt
1620: WHERE

Line 2006: po_distributions pod,

2002: ),
2003: gt.num1,
2004: gt.char3
2005: FROM
2006: po_distributions pod,
2007: po_line_locations poll,
2008: po_lines pol,
2009: po_session_gt gt
2010: WHERE

Line 2203: FROM po_distributions_all pod

2199: Nvl(poll.quantity_received, 0))
2200: , 'QTY2', (SELECT Sum(Decode(poll.matching_basis, 'AMOUNT',
2201: Nvl(pod.amount_delivered, 0),
2202: Nvl(pod.quantity_delivered, 0)))
2203: FROM po_distributions_all pod
2204: WHERE pod.line_location_id=poll.line_location_id)
2205: , 'DOC_NUM', gt.char6
2206: ),
2207: gt.num1,

Line 2221: FROM po_distributions_all

2217: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
2218: AND gt.char2 <> po_document_cancel_pvt.c_doc_subtype_PLANNED
2219: AND ((poll.matching_basis = 'AMOUNT'
2220: AND nvl(poll.amount_received, 0) <>(SELECT Sum(Nvl(amount_delivered, 0))
2221: FROM po_distributions_all
2222: WHERE line_location_id=poll.line_location_id))
2223: OR (poll.matching_basis <>'AMOUNT'
2224: AND Nvl(poll.quantity_received, 0) <> (SELECT Sum(Nvl(quantity_delivered, 0))
2225: FROM po_distributions_all

Line 2225: FROM po_distributions_all

2221: FROM po_distributions_all
2222: WHERE line_location_id=poll.line_location_id))
2223: OR (poll.matching_basis <>'AMOUNT'
2224: AND Nvl(poll.quantity_received, 0) <> (SELECT Sum(Nvl(quantity_delivered, 0))
2225: FROM po_distributions_all
2226: WHERE line_location_id=poll.line_location_id))));
2227:
2228:
2229: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;

Line 2693: po_distributions pod,

2689: ),
2690: gt.num1,
2691: gt.char3
2692: FROM
2693: po_distributions pod,
2694: po_line_locations poll,
2695: po_lines pol,
2696: po_session_gt gt,
2697: FINANCIALS_SYSTEM_PARAMETERS FSP,

Line 2862: po_distributions pod,

2858: ),
2859: gt.num1,
2860: gt.char3
2861: FROM
2862: po_distributions pod,
2863: po_line_locations poll,
2864: po_lines pol,
2865: gl_code_combinations gcc,
2866: po_session_gt gt

Line 4898: -- Po Distributions : Amount Ordered and Quantity Ordered

4894: --Function:
4895: -- Reverts the non archived changes[only vital columns] in the base tables
4896: -- If the user i/p flag "Revert_change_flag" is set to Y.
4897: -- Following columns are reverted :
4898: -- Po Distributions : Amount Ordered and Quantity Ordered
4899: -- Po Shipments : Amount,Quantity,Price Override,Need By date and Promised Date
4900: -- Po Lines : Amount,Quantity and Unit Price
4901:
4902:

Line 4995: UPDATE po_distributions_all pod

4991: PO_DEBUG.debug_var(d_module,l_progress,'l_sequence',l_sequence);
4992: END IF;
4993:
4994: -- Reverting back the distributions amount_ordered and quantity_ordered
4995: UPDATE po_distributions_all pod
4996: SET (amount_ordered ,
4997: quantity_ordered )=
4998: (SELECT
4999: amount_ordered,

Line 5001: FROM po_distributions_archive_all poad

4997: quantity_ordered )=
4998: (SELECT
4999: amount_ordered,
5000: quantity_ordered
5001: FROM po_distributions_archive_all poad
5002: WHERE poad.po_distribution_id =pod.po_distribution_id
5003: AND poad.latest_external_flag ='Y')
5004: WHERE pod.line_location_id IN
5005: (SELECT poll.line_location_id

Line 5358: po_distributions_all pod,

5354: 'E',
5355: gt.num1,
5356: gt.char3
5357: FROM
5358: po_distributions_all pod,
5359: po_line_locations poll,
5360: po_lines pol ,
5361: po_session_gt gt
5362: WHERE

Line 5370: -- Throw an error if the encumbered flag at PO distributions is N for

5366: AND poll.po_line_id = pol.po_line_id
5367: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
5368: AND Nvl(poll.approved_flag,'N')<>'Y'
5369: -- <13503748: Edit without unreserve ER START>
5370: -- Throw an error if the encumbered flag at PO distributions is N for
5371: -- encumbered enabled environment
5372: AND (p_po_enc_flag = 'Y' AND pod.encumbered_flag = 'N')
5373: -- <13503748: Edit without unreserve ER END>
5374: AND (p_po_enc_flag ='Y'

Line 5376: FROM po_distributions_archive_all

5372: AND (p_po_enc_flag = 'Y' AND pod.encumbered_flag = 'N')
5373: -- <13503748: Edit without unreserve ER END>
5374: AND (p_po_enc_flag ='Y'
5375: OR NOT EXISTS (SELECT 'exists archive'
5376: FROM po_distributions_archive_all
5377: WHERE po_distribution_id =pod.po_distribution_id)
5378: )
5379:
5380: );

Line 5485: po_distributions_all pod,

5481: 'E',
5482: gt.num1,
5483: gt.char3
5484: FROM
5485: po_distributions_all pod,
5486: po_line_locations poll,
5487: po_lines pol ,
5488: po_session_gt gt
5489: WHERE

Line 5496: FROM po_distributions_archive_all

5492: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
5493: AND poll.po_line_id = pol.po_line_id
5494: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
5495: AND ((NOT EXISTS (SELECT 'exists archive'
5496: FROM po_distributions_archive_all
5497: WHERE po_distribution_id =pod.po_distribution_id)
5498: AND Nvl(poll.approved_flag,'N')<>'Y')
5499: OR EXISTS (SELECT 'change exists'
5500: FROM po_line_locations_archive_all poall