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.CSD_UPDATE_PROGRAMS_PVT dependencies on RCV_TRANSACTIONS

Line 23: organization_id rcv_transactions.organization_id%type,

19: line_id oe_order_lines_all.line_id%type ,
20: rma_line_number oe_order_lines_all.line_number%type ,
21: inventory_item_id oe_order_lines_all.inventory_item_id%type,
22: org_name hr_all_organization_units.name%type ,
23: organization_id rcv_transactions.organization_id%type,
24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,

Line 24: unit_of_measure rcv_transactions.unit_of_measure%type,

20: rma_line_number oe_order_lines_all.line_number%type ,
21: inventory_item_id oe_order_lines_all.inventory_item_id%type,
22: org_name hr_all_organization_units.name%type ,
23: organization_id rcv_transactions.organization_id%type,
24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,

Line 25: received_quantity rcv_transactions.quantity%type ,

21: inventory_item_id oe_order_lines_all.inventory_item_id%type,
22: org_name hr_all_organization_units.name%type ,
23: organization_id rcv_transactions.organization_id%type,
24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,

Line 26: received_date rcv_transactions.transaction_date%type ,

22: org_name hr_all_organization_units.name%type ,
23: organization_id rcv_transactions.organization_id%type,
24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,
30: transaction_type rcv_transactions.transaction_type%type,

Line 27: transaction_id rcv_transactions.transaction_id%type,

23: organization_id rcv_transactions.organization_id%type,
24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,
30: transaction_type rcv_transactions.transaction_type%type,
31: ro_serial_number csd_repairs.serial_number%type ,

Line 28: subinventory rcv_transactions.subinventory%type,

24: unit_of_measure rcv_transactions.unit_of_measure%type,
25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,
30: transaction_type rcv_transactions.transaction_type%type,
31: ro_serial_number csd_repairs.serial_number%type ,
32: repair_number csd_repairs.repair_number%type,

Line 29: locator_id rcv_transactions.locator_id%type,

25: received_quantity rcv_transactions.quantity%type ,
26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,
30: transaction_type rcv_transactions.transaction_type%type,
31: ro_serial_number csd_repairs.serial_number%type ,
32: repair_number csd_repairs.repair_number%type,
33: ro_uom csd_repairs.unit_of_measure%type,

Line 30: transaction_type rcv_transactions.transaction_type%type,

26: received_date rcv_transactions.transaction_date%type ,
27: transaction_id rcv_transactions.transaction_id%type,
28: subinventory rcv_transactions.subinventory%type,
29: locator_id rcv_transactions.locator_id%type,
30: transaction_type rcv_transactions.transaction_type%type,
31: ro_serial_number csd_repairs.serial_number%type ,
32: repair_number csd_repairs.repair_number%type,
33: ro_uom csd_repairs.unit_of_measure%type,
34: ro_item_id csd_repairs.inventory_item_id%type ,

Line 2147: rcv_transactions rcvt,

2143: ced.inventory_item_id prod_txn_item_id
2144: FROM csd_product_transactions cpt,
2145: cs_estimate_details ced,
2146: csd_repairs cra,
2147: rcv_transactions rcvt,
2148: oe_order_headers_all oeh,
2149: oe_order_lines_all oel,
2150: hr_all_organization_units haou
2151: WHERE cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off

Line 2224: rcv_transactions rcvt,

2220: ced.inventory_item_id prod_txn_item_id
2221: FROM csd_product_transactions cpt,
2222: cs_estimate_details ced,
2223: csd_repairs cra,
2224: rcv_transactions rcvt,
2225: oe_order_headers_all oeh,
2226: oe_order_lines_all oel,
2227: hr_all_organization_units haou
2228: WHERE cra.creation_date between p_from_date and p_to_date

Line 2297: rcv_transactions rcvt,

2293: FROM hr_all_organization_units haou,
2294: csd_repairs cra,
2295: oe_order_headers_all oeh,
2296: oe_order_lines_all oel,
2297: rcv_transactions rcvt,
2298: cs_estimate_details ced,
2299: csd_product_transactions cpt
2300: WHERE cpt.repair_line_id = p_repair_line_id
2301: AND cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off

Line 2359: rcv_transactions rt

2355: Cursor rcv_txn_serial_num (p_txn_id in number) is
2356: select rst.serial_num,
2357: rst.lot_num
2358: from rcv_serial_transactions rst,
2359: rcv_transactions rt
2360: where rt.transaction_id = p_txn_id
2361: and rst.transaction_id = rt.transaction_id;
2362:
2363:

Line 3220: from rcv_transactions rcv,

3216: mtl.serial_number_control_code,
3217: mtl.comms_nl_trackable_flag ib_flag,
3218: mtl.lot_control_code,
3219: hao.name org_name
3220: from rcv_transactions rcv,
3221: po_requisition_lines_all prl,
3222: po_requisition_headers_all prh,
3223: mtl_system_items mtl,
3224: hr_all_organization_units hao

Line 3243: from rcv_transactions rcvt,

3239: rcvt.quantity rcvd_qty,
3240: rcvt.organization_id,
3241: rcvt.locator_id,
3242: hao.name org_name
3243: from rcv_transactions rcvt,
3244: hr_all_organization_units hao
3245: where rcvt.parent_transaction_id = p_txn_id
3246: and rcvt.transaction_type = 'DELIVER';
3247:

Line 4636: from rcv_transactions rcv,

4632: mtl.serial_number_control_code,
4633: mtl.comms_nl_trackable_flag ib_flag,
4634: mtl.lot_control_code,
4635: hao.name org_name
4636: from rcv_transactions rcv,
4637: po_requisition_lines_all prl,
4638: po_requisition_headers_all prh,
4639: mtl_system_items mtl,
4640: hr_all_organization_units hao

Line 4659: from rcv_transactions rcvt,

4655: rcvt.quantity rcvd_qty,
4656: rcvt.organization_id,
4657: rcvt.locator_id,
4658: hao.name org_name
4659: from rcv_transactions rcvt,
4660: hr_all_organization_units hao
4661: where rcvt.parent_transaction_id = p_txn_id
4662: and rcvt.transaction_type = 'DELIVER';
4663: