eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_RETURN dependencies on RCV_TRANSACTIONS

Line 24: FROM rcv_transactions rt,

20: rt.po_line_location_id, rt.deliver_to_person_id,
21: rt.deliver_to_location_id, rt.po_distribution_id,
22: rt.locator_id, rsl.item_description, rt.subinventory,
23: rt.reason_id, rt.transfer_lpn_id, rt.lpn_id
24: FROM rcv_transactions rt,
25: rcv_shipment_lines rsl,
26: rcv_shipment_headers rsh
27: WHERE rt.transaction_id = v_parent_trx_id
28: AND rt.shipment_line_id = rsl.shipment_line_id

Line 41: FROM rcv_transactions rt2

37: )
38: OR ( rt.transaction_type = 'UNORDERED'
39: AND NOT EXISTS (
40: SELECT 'PROCESSED MATCH ROWS'
41: FROM rcv_transactions rt2
42: WHERE rt2.parent_transaction_id =
43: rt.transaction_id
44: AND rt2.transaction_type = 'MATCH')
45: AND NOT EXISTS (

Line 47: FROM rcv_transactions_interface rti

43: rt.transaction_id
44: AND rt2.transaction_type = 'MATCH')
45: AND NOT EXISTS (
46: SELECT 'UNPROCESSED MATCH ROWS'
47: FROM rcv_transactions_interface rti
48: WHERE rti.parent_transaction_id =
49: rt.transaction_id
50: AND rti.transaction_type = 'MATCH')
51: )

Line 61: FROM rcv_transactions_interface rti

57: AND rs.to_org_primary_quantity >
58: (SELECT NVL (SUM (rti.primary_quantity),
59: 0
60: )
61: FROM rcv_transactions_interface rti
62: WHERE rti.parent_transaction_id =
63: rt.transaction_id
64: AND rti.transaction_status_code =
65: 'PENDING'))

Line 94: FROM rcv_transactions_interface rti

90: rti.po_line_location_id, rti.deliver_to_person_id,
91: rti.deliver_to_location_id, rti.po_distribution_id,
92: rti.locator_id, rti.item_description, rti.subinventory,
93: rti.reason_id, rti.transfer_lpn_id,rti.lpn_id
94: FROM rcv_transactions_interface rti
95: WHERE interface_transaction_id = v_parent_inter_trx_id;
96:
97: PROCEDURE derive_return_line (
98: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,

217: n IN BINARY_INTEGER
218: );
219:
220: PROCEDURE derive_inv_qty_1(
221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,
222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,

Line 222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,

218: );
219:
220: PROCEDURE derive_inv_qty_1(
221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,
222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,

Line 223: p_quantity IN rcv_transactions_interface.quantity%type,

219:
220: PROCEDURE derive_inv_qty_1(
221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,
222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,

Line 224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,

220: PROCEDURE derive_inv_qty_1(
221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,
222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,

Line 225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,

221: p_destination_type_code IN rcv_transactions_interface.destination_type_code%type,
222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,

Line 226: p_item_id IN rcv_transactions_interface.item_id%type,

222: p_transaction_type IN rcv_transactions_interface.transaction_type%type,
223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,

Line 227: p_item_revision IN rcv_transactions_interface.item_revision%type,

223: p_quantity IN rcv_transactions_interface.quantity%type,
224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,

Line 228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,

224: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,
225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,

Line 229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,

225: p_to_organization_id IN rcv_transactions_interface.to_organization_id%type,
226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,

Line 230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,

226: p_item_id IN rcv_transactions_interface.item_id%type,
227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,

Line 231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,

227: p_item_revision IN rcv_transactions_interface.item_revision%type,
228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,
235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,

Line 232: p_subinventory IN rcv_transactions_interface.subinventory%type,

228: p_receipt_source_code IN rcv_transactions_interface.receipt_source_code%type,
229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,
235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,
236: x_error_status IN OUT NOCOPY VARCHAR2,

Line 233: p_locator_id IN rcv_transactions_interface.locator_id%type,

229: p_po_header_id IN rcv_transactions_interface.po_header_id%type,
230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,
235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,
236: x_error_status IN OUT NOCOPY VARCHAR2,
237: x_error_message IN OUT NOCOPY VARCHAR2

Line 234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,

230: p_unit_of_measure IN rcv_transactions_interface.unit_of_measure%type,
231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,
235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,
236: x_error_status IN OUT NOCOPY VARCHAR2,
237: x_error_message IN OUT NOCOPY VARCHAR2
238: );

Line 235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,

231: p_primary_unit_of_measure IN rcv_transactions_interface.primary_unit_of_measure%type,
232: p_subinventory IN rcv_transactions_interface.subinventory%type,
233: p_locator_id IN rcv_transactions_interface.locator_id%type,
234: p_transfer_lpn_id IN rcv_transactions_interface.transfer_lpn_id%type,
235: p_lpn_id IN rcv_transactions_interface.lpn_id%type,
236: x_error_status IN OUT NOCOPY VARCHAR2,
237: x_error_message IN OUT NOCOPY VARCHAR2
238: );
239: