DBA Data[Home] [Help]

APPS.PO_CHARGES_GRP dependencies on RCV_TRANSACTIONS

Line 75: FROM rcv_transactions rt,

71: SELECT shipment_header_id
72: BULK COLLECT INTO l_rsh_id_table
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

Line 472: FROM rcv_transactions rt,

468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469:
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