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 OE_ORDER_HEADERS_ALL

Line 17: rma_number oe_order_headers_all.order_number%type,

13:
14: -- Added by Vijay 10/22/04
15: TYPE RCPT_LINES_Rec_Type IS RECORD
16: (
17: rma_number oe_order_headers_all.order_number%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,

Line 18: rma_header_id oe_order_headers_all.header_id%type ,

14: -- Added by Vijay 10/22/04
15: TYPE RCPT_LINES_Rec_Type IS RECORD
16: (
17: rma_number oe_order_headers_all.order_number%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 ,

Line 62: order_number oe_order_headers_all.order_number%type

58: inventory_item_id csd_repairs.inventory_item_id%type,
59: ro_uom csd_repairs.unit_of_measure%type,
60: requisition_number po_requisition_headers_all.segment1%type,
61: ordered_quantity oe_order_lines_all.ordered_quantity%type,
62: order_number oe_order_headers_all.order_number%type
63: );
64:
65: TYPE SHIP_LINES_Rec_Type IS RECORD
66: (

Line 2148: oe_order_headers_all oeh,

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
2152: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')

Line 2225: oe_order_headers_all oeh,

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
2229: AND cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off

Line 2295: oe_order_headers_all oeh,

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,
2298: cs_estimate_details ced,
2299: csd_product_transactions cpt

Line 3147: oe_order_headers_all oeh

3143: from csd_product_transactions cpt,
3144: csd_repairs cra,
3145: po_requisition_headers_all prh,
3146: oe_order_lines_all oel,
3147: oe_order_headers_all oeh
3148: where cpt.repair_line_id = cra.repair_line_id
3149: AND cpt.req_header_id = prh.requisition_header_id
3150: AND cpt.order_line_id = oel.line_id
3151: AND oel.header_id = oeh.header_id

Line 3183: oe_order_headers_all oeh

3179: from csd_product_transactions cpt,
3180: csd_repairs cra,
3181: po_requisition_headers_all prh,
3182: oe_order_lines_all oel,
3183: oe_order_headers_all oeh
3184: where cpt.repair_line_id = cra.repair_line_id
3185: AND cpt.req_header_id = prh.requisition_header_id
3186: AND cpt.order_line_id = oel.line_id
3187: AND oel.header_id = oeh.header_id

Line 3292: from oe_order_headers_all oeh,

3288: IF NVL(p_order_header_id,-999) <> -999 THEN
3289: BEGIN
3290: select 'EXISTS'
3291: into l_dummy
3292: from oe_order_headers_all oeh,
3293: po_requisition_headers_all prh
3294: where oeh.source_document_id = prh.requisition_header_id
3295: and oeh.header_id = p_order_header_id
3296: and exists (select 'x'

Line 4561: oe_order_headers_all oeh

4557: from csd_product_transactions cpt,
4558: csd_repairs cra,
4559: po_requisition_headers_all prh,
4560: oe_order_lines_all oel,
4561: oe_order_headers_all oeh
4562: where cpt.repair_line_id = cra.repair_line_id
4563: AND cpt.req_header_id = prh.requisition_header_id
4564: AND cpt.order_line_id = oel.line_id
4565: AND oel.header_id = oeh.header_id

Line 4597: oe_order_headers_all oeh

4593: from csd_product_transactions cpt,
4594: csd_repairs cra,
4595: po_requisition_headers_all prh,
4596: oe_order_lines_all oel,
4597: oe_order_headers_all oeh
4598: where cpt.repair_line_id = cra.repair_line_id
4599: AND cpt.req_header_id = prh.requisition_header_id
4600: AND cpt.order_line_id = oel.line_id
4601: AND oel.header_id = oeh.header_id

Line 4708: from oe_order_headers_all oeh,

4704: IF NVL(p_order_header_id,-999) <> -999 THEN
4705: BEGIN
4706: select 'EXISTS'
4707: into l_dummy
4708: from oe_order_headers_all oeh,
4709: po_requisition_headers_all prh
4710: where oeh.source_document_id = prh.requisition_header_id
4711: and oeh.header_id = p_order_header_id
4712: and exists (select 'x'

Line 7232: from oe_order_headers_all oeh,

7228: IF NVL(p_order_header_id,-999) <> -999 THEN
7229: BEGIN
7230: select 'EXISTS'
7231: into l_dummy
7232: from oe_order_headers_all oeh,
7233: po_requisition_headers_all prh
7234: where oeh.source_document_id = prh.requisition_header_id
7235: and oeh.header_id = p_order_header_id
7236: and exists (select 'x'

Line 9419: FROM oe_order_headers_all oeh,

9415: PROCEDURE check_for_cancelled_order(p_repair_line_id NUMBER) IS
9416:
9417: CURSOR CANCELLED_ORDER_LINES(p_repair_line_id NUMBER) IS
9418: SELECT DISTINCT cpt.product_transaction_id PRODUCT_TXN_ID
9419: FROM oe_order_headers_all oeh,
9420: oe_order_lines_all oel,
9421: cs_estimate_details ced,
9422: csd_product_transactions cpt
9423: WHERE cpt.repair_line_id = p_repair_line_id