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 200: po_line_locations_all plla

196: BULK COLLECT INTO l_line_rec_table
197: FROM rcv_shipment_lines rsl,
198: po_lines_all pla,
199: po_headers_all pha,
200: po_line_locations_all plla
201: WHERE rsl.po_line_id = pla.po_line_id
202: AND rsl.po_header_id = pha.po_header_id
203: ANd rsl.po_line_location_id = plla.line_location_id
204: AND rsl.shipment_header_id = l_rsh_id

Line 444: po_line_locations_all pll -- lcm changes

440: SELECT DISTINCT shipment_header_id
441: BULK COLLECT INTO l_rsh_id_table
442: FROM rcv_transactions rt,
443: rcv_parameters rp,
444: po_line_locations_all pll -- lcm changes
445: WHERE rt.group_id = decode(p_group_id, 0, rt.group_id, p_group_id)
446: AND rt.request_id = p_request_id -- 0 for online mode
447: AND rt.transaction_type = 'RECEIVE'
448: AND rt.source_document_code = 'PO'