APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1145: po_distributions_all pod,

1141: from po_change_requests pcr,
1142: po_headers_all poh,
1143: po_lines_all pol,
1144: po_line_locations_all pll,
1145: po_distributions_all pod,
1146: po_releases_all por
1147: where pcr.change_request_group_id=p_change_request_group_id
1148: and pcr.request_status='PENDING'
1149: and pcr.parent_change_request_id is not null

Line 3213: po_distributions_all pod,

3209: po_line_locations_all pll,
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,
3215: po_lines_all pol
3216: where pcr.change_request_group_id=l_change_request_group_id
3217: and pcr.request_status='MGR_APP'

Line 10792: po_distributions_all pod

10788: FROM
10789: po_change_requests pcr, -- for quantity/amount change
10790: po_change_requests pcr1, -- for unit price change
10791: po_lines_all pl,
10792: po_distributions_all pod
10793: WHERE pl.po_line_id = pod.po_line_id
10794: AND pcr.change_request_group_id = p_pochggrp_id
10795: AND pcr.action_type(+) = 'MODIFICATION'
10796: AND pcr.request_status(+) NOT IN ('ACCEPTED', 'REJECTED')

Line 11077: po_distributions_all pod

11073: po_change_requests pcr,
11074: po_change_requests pcr1,
11075: po_change_requests pcr2,
11076: po_lines_all pl,
11077: po_distributions_all pod
11078: WHERE pl.po_line_id = pod.po_line_id
11079: AND pcr.change_request_group_id(+) = p_pochggrp_id
11080: AND pcr.action_type(+) = 'MODIFICATION'
11081: AND pcr.request_status(+) NOT IN ('ACCEPTED', 'REJECTED')