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 145: from po_lookup_codes

141:
142: x_progress := 10;
143: select displayed_field
144: into x_receiving
145: from po_lookup_codes
146: where lookup_type = 'RCV DESTINATION TYPE'
147: and lookup_code = 'RECEIVING';
148:
149: RETURN(x_receiving);

Line 681: from po_lookup_codes plc

677: x_destination_context := 'INVENTORY';
678:
679: select plc.displayed_field
680: into l_destination_type_dsp
681: from po_lookup_codes plc
682: where plc.lookup_type = 'RCV DESTINATION TYPE'
683: and plc.lookup_code = l_destination_type_code;
684:
685: /* Bug#4684017.Project and task info was not getting defaulted for a RMA.

Line 1171: from po_lookup_codes plc

1167: x_destination_context := 'RECEIVING';
1168:
1169: select plc.displayed_field
1170: into l_destination_type_dsp
1171: from po_lookup_codes plc
1172: where plc.lookup_type = 'RCV DESTINATION TYPE'
1173: and plc.lookup_code = l_destination_type_code;
1174:
1175: