DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PO_LOOKUP_CODES

Line 68: po_lookup_codes plc,

64: x_project_id, -- bug 5220069
65: x_task_id, -- bug 5220069
66: l_code_combination_id --
67: from po_distributions pod,
68: po_lookup_codes plc,
69: mtl_supply ms,
70: mtl_kanban_cards mkc --
71: where ms.supply_type_code = 'RECEIVING'
72: and ms.supply_source_id = x_rcv_transaction_id

Line 157: from po_lookup_codes

153:
154: x_progress := 10;
155: select displayed_field
156: into x_receiving
157: from po_lookup_codes
158: where lookup_type = 'RCV DESTINATION TYPE'
159: and lookup_code = 'RECEIVING';
160:
161: RETURN(x_receiving);

Line 708: from po_lookup_codes plc

704: x_destination_context := 'INVENTORY';
705:
706: select plc.displayed_field
707: into l_destination_type_dsp
708: from po_lookup_codes plc
709: where plc.lookup_type = 'RCV DESTINATION TYPE'
710: and plc.lookup_code = l_destination_type_code;
711:
712: /* Bug#4684017.Project and task info was not getting defaulted for a RMA.

Line 1198: from po_lookup_codes plc

1194: x_destination_context := 'RECEIVING';
1195:
1196: select plc.displayed_field
1197: into l_destination_type_dsp
1198: from po_lookup_codes plc
1199: where plc.lookup_type = 'RCV DESTINATION TYPE'
1200: and plc.lookup_code = l_destination_type_code;
1201:
1202: