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 HR_ALL_ORGANIZATION_UNITS

Line 22: org_name hr_all_organization_units.name%type ,

18: rma_header_id oe_order_headers_all.header_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 ,

Line 93: org_name hr_all_organization_units.name%type

89: source_instance_id csd_product_transactions.source_instance_id%type,
90: product_transaction_id csd_product_transactions.product_transaction_id%type,
91: action_code csd_product_transactions.action_code%type,
92: delivery_name wsh_new_deliveries.name%type ,
93: org_name hr_all_organization_units.name%type
94: );
95: TYPE IO_SHIP_LINES_Rec_Type IS RECORD
96: (
97: header_id oe_order_lines_all.header_id%type,

Line 122: source_org_name hr_all_organization_units.name%type ,

118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,
123: destination_org_name hr_all_organization_units.name%type ,
124: txn_source_id mtl_txn_request_lines.txn_source_id%type
125: );
126:

Line 123: destination_org_name hr_all_organization_units.name%type ,

119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,
123: destination_org_name hr_all_organization_units.name%type ,
124: txn_source_id mtl_txn_request_lines.txn_source_id%type
125: );
126:
127: TYPE JOB_COMPLETION_Rec_Type IS RECORD

Line 2150: hr_all_organization_units haou

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
2152: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')
2153: AND ced.order_header_id is not null
2154: AND rcvt.oe_order_line_id = ced.order_line_id ----bug#6753684, 6742512

Line 2227: hr_all_organization_units haou

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
2229: AND cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off
2230: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')
2231: AND ced.order_header_id is not null

Line 2293: FROM hr_all_organization_units haou,

2289: cpt.quantity_received prod_txn_recd_qty,
2290: abs(ced.quantity_required) estimate_quantity,
2291: ced.order_line_id est_order_line_id,
2292: ced.inventory_item_id prod_txn_item_id
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,

Line 3224: hr_all_organization_units hao

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
3225: where rcv.requisition_line_id = prl.requisition_line_id
3226: and prl.item_id = mtl.inventory_item_id
3227: and prl.destination_organization_id = mtl.organization_id
3228: and prl.requisition_header_id = prh.requisition_header_id

Line 3244: hr_all_organization_units hao

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:
3248: CURSOR ORDER_INFO (p_ord_header_id in number) IS

Line 4640: hr_all_organization_units hao

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
4641: where rcv.requisition_line_id = prl.requisition_line_id
4642: and prl.item_id = mtl.inventory_item_id
4643: and prl.destination_organization_id = mtl.organization_id
4644: and prl.requisition_header_id = prh.requisition_header_id

Line 4660: hr_all_organization_units hao

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:
4664: CURSOR ORDER_INFO (p_ord_header_id in number) IS

Line 6191: hr_all_organization_units hao

6187: --Changed to view from table, bug: 4341784
6188: wsh_delivery_assignments_v wda,
6189: wsh_new_deliveries wnd,
6190: oe_order_lines_all oel,
6191: hr_all_organization_units hao
6192: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6193: AND cpt.estimate_detail_id = ced.estimate_detail_id
6194: AND dd.delivery_detail_id = wda.delivery_detail_id
6195: AND dd.delivery_detail_id = dsn.delivery_detail_id(+) --Added to fix 3801614

Line 6267: hr_all_organization_units hao

6263: --Changed to view from table, bug: 4341784
6264: wsh_delivery_assignments_v wda,
6265: wsh_new_deliveries wnd,
6266: oe_order_lines_all oel,
6267: hr_all_organization_units hao
6268: Where cra.creation_date between p_from_date and p_to_date
6269: AND cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6270: AND cpt.estimate_detail_id = ced.estimate_detail_id
6271: AND dd.delivery_detail_id = wda.delivery_detail_id

Line 6351: hr_all_organization_units hao

6347: --Changed to view from table, bug: 4341784
6348: wsh_delivery_assignments_v wda,
6349: wsh_new_deliveries wnd,
6350: oe_order_lines_all oel,
6351: hr_all_organization_units hao
6352: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6353: AND cpt.estimate_detail_id = ced.estimate_detail_id
6354: AND dd.delivery_detail_id = wda.delivery_detail_id
6355: AND dd.delivery_detail_id = dsn.delivery_detail_id(+) --Added to fix 3801614

Line 7042: hr_all_organization_units hao,

7038: wsh_serial_numbers dsn,--Added to fix 3801614
7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,
7042: hr_all_organization_units hao,
7043: hr_all_organization_units hao1,
7044: mtl_txn_request_lines trl
7045: where oel.header_id = p_ord_header_id
7046: and oel.line_id = dd.source_line_id

Line 7043: hr_all_organization_units hao1,

7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,
7042: hr_all_organization_units hao,
7043: hr_all_organization_units hao1,
7044: mtl_txn_request_lines trl
7045: where oel.header_id = p_ord_header_id
7046: and oel.line_id = dd.source_line_id
7047: and oel.header_id = dd.source_header_id

Line 7099: hr_all_organization_units hao,

7095: wsh_serial_numbers dsn,--Added to fix 3801614
7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,
7099: hr_all_organization_units hao,
7100: hr_all_organization_units hao1,
7101: mtl_txn_request_lines trl
7102: where oel.line_id = dd.source_line_id
7103: and oel.header_id = dd.source_header_id

Line 7100: hr_all_organization_units hao1,

7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,
7099: hr_all_organization_units hao,
7100: hr_all_organization_units hao1,
7101: mtl_txn_request_lines trl
7102: where oel.line_id = dd.source_line_id
7103: and oel.header_id = dd.source_header_id
7104: and prl.requisition_header_id = prh.requisition_header_id