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_DOCUMENT_CANCEL_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 606: UPDATE PO_DISTRIBUTIONS_ALL POD

602: END IF;
603:
604: l_progress := '002' ;
605:
606: UPDATE PO_DISTRIBUTIONS_ALL POD
607: SET (POD.quantity_billed,POD.quantity_delivered) =
608: ( SELECT SUM( NVL(RELD.quantity_billed, 0) ),
609: SUM( NVL(RELD.quantity_delivered, 0) )
610: FROM PO_DISTRIBUTIONS RELD

Line 754: PO_DISTRIBUTIONS_ALL POD

750:
751: l_progress := '001' ;
752:
753: UPDATE
754: PO_DISTRIBUTIONS_ALL POD
755: SET
756: pod.quantity_cancelled = pod.quantity_ordered-greatest(
757: NVL(quantity_delivered,0),
758: NVL(quantity_financed,0),

Line 797: UPDATE PO_DISTRIBUTIONS_ALL POD

793: ELSE
794:
795: l_progress := '002' ;
796:
797: UPDATE PO_DISTRIBUTIONS_ALL POD
798: SET pod.gl_cancelled_date = p_action_date,
799: pod.req_distribution_id = Decode(
800: p_recreate_demand,
801: 'Y',

Line 981: FROM PO_DISTRIBUTIONS_ALL POD

977: -1,
978: request_id,
979: l_request_id) ,
980: POLL.quantity_cancelled = (SELECT SUM(NVL(POD.quantity_cancelled,0))
981: FROM PO_DISTRIBUTIONS_ALL POD
982: WHERE POD.line_location_id=POLL.line_location_id),
983: POLL.amount_cancelled = (SELECT SUM(NVL(POD.amount_cancelled, 0))
984: FROM PO_DISTRIBUTIONS_ALL POD
985: WHERE POD.line_location_id=POLL.line_location_id)

Line 984: FROM PO_DISTRIBUTIONS_ALL POD

980: POLL.quantity_cancelled = (SELECT SUM(NVL(POD.quantity_cancelled,0))
981: FROM PO_DISTRIBUTIONS_ALL POD
982: WHERE POD.line_location_id=POLL.line_location_id),
983: POLL.amount_cancelled = (SELECT SUM(NVL(POD.amount_cancelled, 0))
984: FROM PO_DISTRIBUTIONS_ALL POD
985: WHERE POD.line_location_id=POLL.line_location_id)
986: WHERE NVL(poll.cancel_flag, 'N') = 'N'
987: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
988: AND POLL.line_location_id IN

Line 2649: po_distributions_all pod

2645: CURSOR l_before_fc_csr IS
2646: SELECT DISTINCT(prd.requisition_line_id)
2647: FROM po_req_distributions_all prd,
2648: po_line_locations poll ,
2649: po_distributions_all pod
2650: WHERE pod.line_location_id = poll.line_location_id
2651: AND pod.req_distribution_id = prd.distribution_id
2652: AND NVL(poll.cancel_flag, 'N') = 'I'
2653: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2959: FROM PO_DISTRIBUTIONS_ALL POd ,

2955: )
2956: )
2957: )
2958: INTO x_qty_cancelled
2959: FROM PO_DISTRIBUTIONS_ALL POd ,
2960: po_req_distributions_all pord,
2961: po_line_locations POLL
2962: WHERE pord.requisition_line_id = p_req_line_id
2963: AND pord.distribution_id = pod.req_distribution_id

Line 3123: PO_DISTRIBUTIONS_ALL POD

3119: SUM(l_uom_conv * (greatest(NVL(POD.quantity_delivered, 0),
3120: NVL(POD.quantity_billed, 0)) )) )
3121:
3122: FROM po_line_locations POLL,
3123: PO_DISTRIBUTIONS_ALL POD
3124: WHERE POD.req_distribution_id = PORD.distribution_id
3125: AND POLL.line_location_id = POD.line_location_id
3126: AND POLL.shipment_type IN ('STANDARD',
3127: 'PLANNED' ,

Line 3184: PO_DISTRIBUTIONS_ALL POD

3180: NVL(POD.quantity_billed, 0))
3181: )
3182: )
3183: FROM po_line_locations POLL,
3184: PO_DISTRIBUTIONS_ALL POD
3185: WHERE POD.req_distribution_id = PORD.distribution_id
3186: AND POLL.line_location_id = POD.line_location_id
3187: AND POLL.shipment_type IN ('STANDARD' ,
3188: 'PLANNED' ,

Line 3441: FROM PO_DISTRIBUTIONS_ALL POD,

3437: BEGIN
3438: SELECT SUM(greatest(pod.quantity_delivered,
3439: pod.quantity_billed))
3440: INTO l_qzero
3441: FROM PO_DISTRIBUTIONS_ALL POD,
3442: PO_REQ_DISTRIBUTIONS_ALL PORD
3443: WHERE POD.req_distribution_id = PORD.distribution_id
3444: AND PORD.requisition_line_id = p_req_line_id;
3445:

Line 4045: PO_DISTRIBUTIONS_ALL POD ,

4041: FROM
4042: PO_REQ_DISTRIBUTIONS_ALL PORD ,
4043: PO_REQUISITION_LINES_ALL PORL_OLD,
4044: PO_REQUISITION_LINES_ALL PORL_NEW,
4045: PO_DISTRIBUTIONS_ALL POD ,
4046: PO_LINE_LOCATIONS PLL ,
4047: po_headers BLANKET
4048: WHERE
4049: PORL_NEW.requisition_line_id = p_req_line_id

Line 4356: PO_DISTRIBUTIONS_ALL POD ,

4352: BLANKET.encumbrance_required_flag,
4353: NULL)),
4354: 'N')
4355: FROM PO_REQUISITION_LINES_ALL PORL,
4356: PO_DISTRIBUTIONS_ALL POD ,
4357: po_line_locations PLL ,
4358: po_headers BLANKET
4359: WHERE PORL.requisition_line_id = PORD.requisition_line_id
4360: AND POD.req_distribution_id = PORD.distribution_id

Line 4404: FROM po_distributions_all poda,

4400: FROM po_requisition_lines_all porl
4401: WHERE porl.requisition_line_id = PORD.requisition_line_id
4402: AND porl.blanket_po_header_id IS NULL)
4403: AND EXISTS (SELECT 1
4404: FROM po_distributions_all poda,
4405: po_lines pol,
4406: po_distributions_all pod
4407: WHERE poda.po_header_id = pol.from_header_id
4408: AND pol.po_line_id = pod.po_line_id

Line 4406: po_distributions_all pod

4402: AND porl.blanket_po_header_id IS NULL)
4403: AND EXISTS (SELECT 1
4404: FROM po_distributions_all poda,
4405: po_lines pol,
4406: po_distributions_all pod
4407: WHERE poda.po_header_id = pol.from_header_id
4408: AND pol.po_line_id = pod.po_line_id
4409: AND pod.req_distribution_id = pord.distribution_id
4410: AND pod.distribution_type = c_doc_subtype_STANDARD

Line 4413: FROM po_distributions_all poda,

4409: AND pod.req_distribution_id = pord.distribution_id
4410: AND pod.distribution_type = c_doc_subtype_STANDARD
4411: UNION
4412: SELECT 1
4413: FROM po_distributions_all poda,
4414: po_distributions_all pod
4415: WHERE pod.req_distribution_id = pord.distribution_id
4416: AND pod.distribution_type = c_doc_subtype_BLANKET
4417: AND pod.po_header_id = poda.po_header_id

Line 4414: po_distributions_all pod

4410: AND pod.distribution_type = c_doc_subtype_STANDARD
4411: UNION
4412: SELECT 1
4413: FROM po_distributions_all poda,
4414: po_distributions_all pod
4415: WHERE pod.req_distribution_id = pord.distribution_id
4416: AND pod.distribution_type = c_doc_subtype_BLANKET
4417: AND pod.po_header_id = poda.po_header_id
4418: AND poda.distribution_type = 'AGREEMENT');

Line 6863: PO_DISTRIBUTIONS_ALL POD

6859:
6860: l_progress := '003' ;
6861:
6862: UPDATE
6863: PO_DISTRIBUTIONS_ALL POD
6864: SET
6865: pod.quantity_cancelled = pod.quantity_ordered-greatest(
6866: NVL(quantity_delivered,0),
6867: NVL(quantity_financed,0),

Line 6889: FROM PO_DISTRIBUTIONS_ALL POD

6885: SET POLL.last_update_date = p_action_date,
6886: POLL.last_updated_by = l_user_id,
6887: POLL.last_update_login = l_login_id,
6888: POLL.quantity_cancelled = (SELECT SUM(NVL(POD.quantity_cancelled,0))
6889: FROM PO_DISTRIBUTIONS_ALL POD
6890: WHERE POD.line_location_id=POLL.line_location_id),
6891: POLL.amount_cancelled = (SELECT SUM(NVL(POD.amount_cancelled, 0))
6892: FROM PO_DISTRIBUTIONS_ALL POD
6893: WHERE POD.line_location_id=POLL.line_location_id)

Line 6892: FROM PO_DISTRIBUTIONS_ALL POD

6888: POLL.quantity_cancelled = (SELECT SUM(NVL(POD.quantity_cancelled,0))
6889: FROM PO_DISTRIBUTIONS_ALL POD
6890: WHERE POD.line_location_id=POLL.line_location_id),
6891: POLL.amount_cancelled = (SELECT SUM(NVL(POD.amount_cancelled, 0))
6892: FROM PO_DISTRIBUTIONS_ALL POD
6893: WHERE POD.line_location_id=POLL.line_location_id)
6894: WHERE poll.line_location_id=l_line_loc_tbl(i);
6895:
6896: IF g_debug_stmt THEN