APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1128: po_distributions_all pod,

1124: from po_change_requests pcr,
1125: po_headers_all poh,
1126: po_lines_all pol,
1127: po_line_locations_all pll,
1128: po_distributions_all pod,
1129: po_releases_all por
1130: where pcr.change_request_group_id=p_change_request_group_id
1131: and pcr.request_status='PENDING'
1132: and pcr.parent_change_request_id is not null

Line 3082: po_distributions_all pod,

3078: po_line_locations_all pll,
3079: po_requisition_lines_all prl,
3080: po_headers_all poh,
3081: po_releases_all por,
3082: po_distributions_all pod,
3083: po_req_distributions_all prd,
3084: po_lines_all pol
3085: where pcr.change_request_group_id=l_change_request_group_id
3086: and pcr.request_status='MGR_APP'

Line 10402: po_distributions_all pod

10398: FROM
10399: po_change_requests pcr, -- for quantity/amount change
10400: po_change_requests pcr1, -- for unit price change
10401: po_lines_all pl,
10402: po_distributions_all pod
10403: WHERE pl.po_line_id = pod.po_line_id
10404: AND pcr.change_request_group_id = p_pochggrp_id
10405: AND pcr.action_type(+) = 'MODIFICATION'
10406: AND pcr.request_status(+) NOT IN ('ACCEPTED', 'REJECTED')

Line 10687: po_distributions_all pod

10683: po_change_requests pcr,
10684: po_change_requests pcr1,
10685: po_change_requests pcr2,
10686: po_lines_all pl,
10687: po_distributions_all pod
10688: WHERE pl.po_line_id = pod.po_line_id
10689: AND pcr.change_request_group_id(+) = p_pochggrp_id
10690: AND pcr.action_type(+) = 'MODIFICATION'
10691: AND pcr.request_status(+) NOT IN ('ACCEPTED', 'REJECTED')