APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_DISTRIBUTIONS_ALL

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 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 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 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 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