APPS.PO_CHARGES_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 77: po_line_locations_all pll -- lcm changes

73: FROM (-- po receipts
74: SELECT rt.shipment_header_id
75: FROM rcv_transactions rt,
76: rcv_parameters rp,
77: po_line_locations_all pll -- lcm changes
78: WHERE rt.group_id = DECODE (p_group_id, 0, rt.group_id, p_group_id)
79: AND rt.request_id = p_request_id
80: AND rt.organization_id = rp.organization_id
81: AND rt.transaction_type = 'RECEIVE'

Line 205: po_line_locations_all plla

201: BULK COLLECT INTO l_line_rec_table
202: FROM rcv_shipment_lines rsl,
203: po_lines_all pla,
204: po_headers_all pha,
205: po_line_locations_all plla
206: WHERE rsl.po_line_id = pla.po_line_id
207: AND rsl.po_header_id = pha.po_header_id
208: ANd rsl.po_line_location_id = plla.line_location_id
209: AND rsl.shipment_header_id = l_rsh_id

Line 474: po_line_locations_all pll -- lcm changes

470: SELECT DISTINCT shipment_header_id
471: BULK COLLECT INTO l_rsh_id_table
472: FROM rcv_transactions rt,
473: rcv_parameters rp,
474: po_line_locations_all pll -- lcm changes
475: WHERE rt.group_id = decode(p_group_id, 0, rt.group_id, p_group_id)
476: AND rt.request_id = p_request_id -- 0 for online mode
477: AND rt.transaction_type = 'RECEIVE'
478: AND rt.source_document_code = 'PO'