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 28: organization_id rcv_transactions.organization_id%type,

24: line_id oe_order_lines_all.line_id%type ,
25: rma_line_number oe_order_lines_all.line_number%type ,
26: inventory_item_id oe_order_lines_all.inventory_item_id%type,
27: org_name hr_all_organization_units.name%type ,
28: organization_id rcv_transactions.organization_id%type,
29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,

Line 29: unit_of_measure rcv_transactions.unit_of_measure%type,

25: rma_line_number oe_order_lines_all.line_number%type ,
26: inventory_item_id oe_order_lines_all.inventory_item_id%type,
27: org_name hr_all_organization_units.name%type ,
28: organization_id rcv_transactions.organization_id%type,
29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,

Line 30: received_quantity rcv_transactions.quantity%type ,

26: inventory_item_id oe_order_lines_all.inventory_item_id%type,
27: org_name hr_all_organization_units.name%type ,
28: organization_id rcv_transactions.organization_id%type,
29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,

Line 31: received_date rcv_transactions.transaction_date%type ,

27: org_name hr_all_organization_units.name%type ,
28: organization_id rcv_transactions.organization_id%type,
29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,
35: transaction_type rcv_transactions.transaction_type%type,

Line 32: transaction_id rcv_transactions.transaction_id%type,

28: organization_id rcv_transactions.organization_id%type,
29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,
35: transaction_type rcv_transactions.transaction_type%type,
36: ro_serial_number csd_repairs.serial_number%type ,

Line 33: subinventory rcv_transactions.subinventory%type,

29: unit_of_measure rcv_transactions.unit_of_measure%type,
30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,
35: transaction_type rcv_transactions.transaction_type%type,
36: ro_serial_number csd_repairs.serial_number%type ,
37: repair_number csd_repairs.repair_number%type,

Line 34: locator_id rcv_transactions.locator_id%type,

30: received_quantity rcv_transactions.quantity%type ,
31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,
35: transaction_type rcv_transactions.transaction_type%type,
36: ro_serial_number csd_repairs.serial_number%type ,
37: repair_number csd_repairs.repair_number%type,
38: ro_uom csd_repairs.unit_of_measure%type,

Line 35: transaction_type rcv_transactions.transaction_type%type,

31: received_date rcv_transactions.transaction_date%type ,
32: transaction_id rcv_transactions.transaction_id%type,
33: subinventory rcv_transactions.subinventory%type,
34: locator_id rcv_transactions.locator_id%type,
35: transaction_type rcv_transactions.transaction_type%type,
36: ro_serial_number csd_repairs.serial_number%type ,
37: repair_number csd_repairs.repair_number%type,
38: ro_uom csd_repairs.unit_of_measure%type,
39: ro_item_id csd_repairs.inventory_item_id%type ,

Line 2207: rcv_transactions rcvt,

2203: ced.inventory_item_id prod_txn_item_id
2204: FROM csd_product_transactions cpt,
2205: cs_estimate_details ced,
2206: csd_repairs cra,
2207: rcv_transactions rcvt,
2208: oe_order_headers_all oeh,
2209: oe_order_lines_all oel,
2210: hr_all_organization_units haou
2211: WHERE cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off

Line 2285: rcv_transactions rcvt,

2281: ced.inventory_item_id prod_txn_item_id
2282: FROM csd_product_transactions cpt,
2283: cs_estimate_details ced,
2284: csd_repairs cra,
2285: rcv_transactions rcvt,
2286: oe_order_headers_all oeh,
2287: oe_order_lines_all oel,
2288: hr_all_organization_units haou
2289: WHERE cra.creation_date between p_from_date and p_to_date

Line 2359: rcv_transactions rcvt,

2355: FROM hr_all_organization_units haou,
2356: csd_repairs cra,
2357: oe_order_headers_all oeh,
2358: oe_order_lines_all oel,
2359: rcv_transactions rcvt,
2360: cs_estimate_details ced,
2361: csd_product_transactions cpt
2362: WHERE cpt.repair_line_id = p_repair_line_id
2363: AND cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off

Line 2421: rcv_transactions rt

2417: Cursor rcv_txn_serial_num (p_txn_id in number) is
2418: select rst.serial_num,
2419: rst.lot_num
2420: from rcv_serial_transactions rst,
2421: rcv_transactions rt
2422: where rt.transaction_id = p_txn_id
2423: and rst.transaction_id = rt.transaction_id;
2424:
2425:

Line 3381: from rcv_transactions rcv,

3377: mtl.serial_number_control_code,
3378: mtl.comms_nl_trackable_flag ib_flag,
3379: mtl.lot_control_code,
3380: hao.name org_name
3381: from rcv_transactions rcv,
3382: po_requisition_lines_all prl,
3383: po_requisition_headers_all prh,
3384: mtl_system_items mtl,
3385: hr_all_organization_units hao

Line 3404: from rcv_transactions rcvt,

3400: rcvt.quantity rcvd_qty,
3401: rcvt.organization_id,
3402: rcvt.locator_id,
3403: hao.name org_name
3404: from rcv_transactions rcvt,
3405: hr_all_organization_units hao
3406: where rcvt.parent_transaction_id = p_txn_id
3407: and rcvt.transaction_type = 'DELIVER';
3408:

Line 4797: from rcv_transactions rcv,

4793: mtl.serial_number_control_code,
4794: mtl.comms_nl_trackable_flag ib_flag,
4795: mtl.lot_control_code,
4796: hao.name org_name
4797: from rcv_transactions rcv,
4798: po_requisition_lines_all prl,
4799: po_requisition_headers_all prh,
4800: mtl_system_items mtl,
4801: hr_all_organization_units hao

Line 4820: from rcv_transactions rcvt,

4816: rcvt.quantity rcvd_qty,
4817: rcvt.organization_id,
4818: rcvt.locator_id,
4819: hao.name org_name
4820: from rcv_transactions rcvt,
4821: hr_all_organization_units hao
4822: where rcvt.parent_transaction_id = p_txn_id
4823: and rcvt.transaction_type = 'DELIVER';
4824: