DBA Data[Home] [Help]

APPS.RCV_CORE_S dependencies on PO_LINE_LOCATIONS

Line 74: FROM po_line_locations

70: x_progress := '020';
71:
72: SELECT ship_to_location_id
73: INTO ship_to_loc_id
74: FROM po_line_locations
75: WHERE line_location_id = x_line_loc_id;
76: ELSE
77: x_progress := '030';
78:

Line 296: -- 1) PO_LINE_LOCATIONS_ALL (...from the PO Shipment)

292: --
293: -- (Overloaded procedure)
294: -- Retrieves default Receiving Controls according to the following hierarchy:
295: --
296: -- 1) PO_LINE_LOCATIONS_ALL (...from the PO Shipment)
297: -- 2) MTL_SYSTEM_ITEMS (...from the Item Master definition)
298: -- 3) PO_VENDORS (...from the Supplier defaults)
299: -- 4) RCV_PARAMETERS (...from the Receiving Controls Setup)
300: --

Line 410: FROM po_line_locations_all

406: x_qty_rcv_exception_code,
407: x_days_early_receipt_allowed,
408: x_days_late_receipt_allowed,
409: x_receipt_days_exception_code
410: FROM po_line_locations_all
411: WHERE line_location_id = p_line_location_id;
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN
414: NULL;

Line 783: ** po_line_locations.

779: x_govt_context OUT NOCOPY VARCHAR2
780: ) IS
781: /*
782: ** Procedure gets ussgl_transaction_code and government_context from
783: ** po_line_locations.
784: */
785: x_progress VARCHAR2(3) := NULL;
786: BEGIN
787: x_progress := '010';

Line 793: FROM po_line_locations

789: SELECT ussgl_transaction_code,
790: government_context
791: INTO x_ussgl_trx_code,
792: x_govt_context
793: FROM po_line_locations
794: WHERE line_location_id = x_line_location_id;
795: EXCEPTION
796: WHEN OTHERS THEN
797: po_message_s.sql_error('get_ussgl_info',

Line 1224: 'PO_LINE_LOCATIONS',

1220: END IF;
1221:
1222: x_progress := 30;
1223: x_ret_note_cnt := note_info('RVCRC',
1224: 'PO_LINE_LOCATIONS',
1225: 'LINE_LOCATION_ID',
1226: x_location_id
1227: );
1228: