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 27: org_name hr_all_organization_units.name%type ,

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

Line 100: org_name hr_all_organization_units.name%type

96: source_instance_id csd_product_transactions.source_instance_id%type,
97: product_transaction_id csd_product_transactions.product_transaction_id%type,
98: action_code csd_product_transactions.action_code%type,
99: delivery_name wsh_new_deliveries.name%type ,
100: org_name hr_all_organization_units.name%type
101: );
102: TYPE IO_SHIP_LINES_Rec_Type IS RECORD
103: (
104: header_id oe_order_lines_all.header_id%type,

Line 129: source_org_name hr_all_organization_units.name%type ,

125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,
130: destination_org_name hr_all_organization_units.name%type ,
131: txn_source_id mtl_txn_request_lines.txn_source_id%type
132: );
133:

Line 130: destination_org_name hr_all_organization_units.name%type ,

126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,
130: destination_org_name hr_all_organization_units.name%type ,
131: txn_source_id mtl_txn_request_lines.txn_source_id%type
132: );
133:
134: TYPE JOB_COMPLETION_Rec_Type IS RECORD

Line 2210: hr_all_organization_units haou

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

Line 2288: hr_all_organization_units haou

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

Line 2355: FROM hr_all_organization_units haou,

2351: cpt.quantity_received prod_txn_recd_qty,
2352: abs(ced.quantity_required) estimate_quantity,
2353: ced.order_line_id est_order_line_id,
2354: ced.inventory_item_id prod_txn_item_id
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,

Line 3385: hr_all_organization_units hao

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
3386: where rcv.requisition_line_id = prl.requisition_line_id
3387: and prl.item_id = mtl.inventory_item_id
3388: and prl.destination_organization_id = mtl.organization_id
3389: and prl.requisition_header_id = prh.requisition_header_id

Line 3405: hr_all_organization_units hao

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

Line 4801: hr_all_organization_units hao

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
4802: where rcv.requisition_line_id = prl.requisition_line_id
4803: and prl.item_id = mtl.inventory_item_id
4804: and prl.destination_organization_id = mtl.organization_id
4805: and prl.requisition_header_id = prh.requisition_header_id

Line 4821: hr_all_organization_units hao

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

Line 6391: hr_all_organization_units hao

6387: --Changed to view from table, bug: 4341784
6388: wsh_delivery_assignments_v wda,
6389: wsh_new_deliveries wnd,
6390: oe_order_lines_all oel,
6391: hr_all_organization_units hao
6392: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6393: AND cpt.estimate_detail_id = ced.estimate_detail_id
6394: AND dd.delivery_detail_id = wda.delivery_detail_id
6395: AND dd.delivery_detail_id = dsn.delivery_detail_id(+) --Added to fix 3801614

Line 6468: hr_all_organization_units hao

6464: --Changed to view from table, bug: 4341784
6465: wsh_delivery_assignments_v wda,
6466: wsh_new_deliveries wnd,
6467: oe_order_lines_all oel,
6468: hr_all_organization_units hao
6469: Where cra.creation_date between p_from_date and p_to_date
6470: AND cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6471: AND cpt.estimate_detail_id = ced.estimate_detail_id
6472: AND dd.delivery_detail_id = wda.delivery_detail_id

Line 6553: hr_all_organization_units hao

6549: --Changed to view from table, bug: 4341784
6550: wsh_delivery_assignments_v wda,
6551: wsh_new_deliveries wnd,
6552: oe_order_lines_all oel,
6553: hr_all_organization_units hao
6554: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6555: AND cpt.estimate_detail_id = ced.estimate_detail_id
6556: AND dd.delivery_detail_id = wda.delivery_detail_id
6557: AND dd.delivery_detail_id = dsn.delivery_detail_id(+) --Added to fix 3801614

Line 7334: hr_all_organization_units hao,

7330: wsh_serial_numbers dsn,--Added to fix 3801614
7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,
7334: hr_all_organization_units hao,
7335: hr_all_organization_units hao1,
7336: mtl_txn_request_lines trl
7337: where oel.header_id = p_ord_header_id
7338: and oel.line_id = dd.source_line_id

Line 7335: hr_all_organization_units hao1,

7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,
7334: hr_all_organization_units hao,
7335: hr_all_organization_units hao1,
7336: mtl_txn_request_lines trl
7337: where oel.header_id = p_ord_header_id
7338: and oel.line_id = dd.source_line_id
7339: and oel.header_id = dd.source_header_id

Line 7391: hr_all_organization_units hao,

7387: wsh_serial_numbers dsn,--Added to fix 3801614
7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,
7391: hr_all_organization_units hao,
7392: hr_all_organization_units hao1,
7393: mtl_txn_request_lines trl
7394: where oel.line_id = dd.source_line_id
7395: and oel.header_id = dd.source_header_id

Line 7392: hr_all_organization_units hao1,

7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,
7391: hr_all_organization_units hao,
7392: hr_all_organization_units hao1,
7393: mtl_txn_request_lines trl
7394: where oel.line_id = dd.source_line_id
7395: and oel.header_id = dd.source_header_id
7396: and prl.requisition_header_id = prh.requisition_header_id