DBA Data[Home] [Help]

APPS.RCV_SHIPMENT_OBJECT_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 45: select rcv_transactions_interface.*,

41: order by transaction_type,shipment_num
42: for update of processing_status_code nowait;
43:
44: cursor c2 (x_header_interface_id number) is
45: select rcv_transactions_interface.*,
46: rowid row_id,
47: uom_class unit_of_measure_class,
48: ship_to_org_id ship_to_organization_id,
49: receipt_code receipt_days_exception_code,

Line 52: from rcv_transactions_interface

48: ship_to_org_id ship_to_organization_id,
49: receipt_code receipt_days_exception_code,
50: error_code error_status,
51: error_text error_message
52: from rcv_transactions_interface
53: where header_interface_id = x_header_interface_id
54: and nvl(validation_flag,'N') = 'Y'
55: order by document_line_num;
56:

Line 89: in the rcv_headers_interface and rcv_transactions_interface tables.

85:
86: DESCRIPTION: Creates the receiving shipment object, namely new rows in the
87: RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES tables. Prior to
88: insert, create_object() will derive, default and validate columns
89: in the rcv_headers_interface and rcv_transactions_interface tables.
90:
91: PARAMETERS:
92:
93: x_request_id: The group of rows that this submission of the