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 22: rma_number oe_order_headers_all.order_number%type,

18:
19: -- Added by Vijay 10/22/04
20: TYPE RCPT_LINES_Rec_Type IS RECORD
21: (
22: rma_number oe_order_headers_all.order_number%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,

Line 23: rma_header_id oe_order_headers_all.header_id%type ,

19: -- Added by Vijay 10/22/04
20: TYPE RCPT_LINES_Rec_Type IS RECORD
21: (
22: rma_number oe_order_headers_all.order_number%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 ,

Line 68: order_number oe_order_headers_all.order_number%type

64: inventory_item_id csd_repairs.inventory_item_id%type,
65: ro_uom csd_repairs.unit_of_measure%type,
66: requisition_number po_requisition_headers_all.segment1%type,
67: ordered_quantity oe_order_lines_all.ordered_quantity%type,
68: order_number oe_order_headers_all.order_number%type
69: );
70:
71: TYPE SHIP_LINES_Rec_Type IS RECORD
72: (

Line 2208: oe_order_headers_all oeh,

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

Line 2286: oe_order_headers_all oeh,

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

Line 2357: oe_order_headers_all oeh,

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,
2360: cs_estimate_details ced,
2361: csd_product_transactions cpt

Line 3308: oe_order_headers_all oeh

3304: from csd_product_transactions cpt,
3305: csd_repairs cra,
3306: po_requisition_headers_all prh,
3307: oe_order_lines_all oel,
3308: oe_order_headers_all oeh
3309: where cpt.repair_line_id = cra.repair_line_id
3310: AND cpt.req_header_id = prh.requisition_header_id
3311: AND cpt.order_line_id = oel.line_id
3312: AND oel.header_id = oeh.header_id

Line 3344: oe_order_headers_all oeh

3340: from csd_product_transactions cpt,
3341: csd_repairs cra,
3342: po_requisition_headers_all prh,
3343: oe_order_lines_all oel,
3344: oe_order_headers_all oeh
3345: where cpt.repair_line_id = cra.repair_line_id
3346: AND cpt.req_header_id = prh.requisition_header_id
3347: AND cpt.order_line_id = oel.line_id
3348: AND oel.header_id = oeh.header_id

Line 3453: from oe_order_headers_all oeh,

3449: IF NVL(p_order_header_id,-999) <> -999 THEN
3450: BEGIN
3451: select 'EXISTS'
3452: into l_dummy
3453: from oe_order_headers_all oeh,
3454: po_requisition_headers_all prh
3455: where oeh.source_document_id = prh.requisition_header_id
3456: and oeh.header_id = p_order_header_id
3457: and exists (select 'x'

Line 4722: oe_order_headers_all oeh

4718: from csd_product_transactions cpt,
4719: csd_repairs cra,
4720: po_requisition_headers_all prh,
4721: oe_order_lines_all oel,
4722: oe_order_headers_all oeh
4723: where cpt.repair_line_id = cra.repair_line_id
4724: AND cpt.req_header_id = prh.requisition_header_id
4725: AND cpt.order_line_id = oel.line_id
4726: AND oel.header_id = oeh.header_id

Line 4758: oe_order_headers_all oeh

4754: from csd_product_transactions cpt,
4755: csd_repairs cra,
4756: po_requisition_headers_all prh,
4757: oe_order_lines_all oel,
4758: oe_order_headers_all oeh
4759: where cpt.repair_line_id = cra.repair_line_id
4760: AND cpt.req_header_id = prh.requisition_header_id
4761: AND cpt.order_line_id = oel.line_id
4762: AND oel.header_id = oeh.header_id

Line 4869: from oe_order_headers_all oeh,

4865: IF NVL(p_order_header_id,-999) <> -999 THEN
4866: BEGIN
4867: select 'EXISTS'
4868: into l_dummy
4869: from oe_order_headers_all oeh,
4870: po_requisition_headers_all prh
4871: where oeh.source_document_id = prh.requisition_header_id
4872: and oeh.header_id = p_order_header_id
4873: and exists (select 'x'

Line 7524: from oe_order_headers_all oeh,

7520: IF NVL(p_order_header_id,-999) <> -999 THEN
7521: BEGIN
7522: select 'EXISTS'
7523: into l_dummy
7524: from oe_order_headers_all oeh,
7525: po_requisition_headers_all prh
7526: where oeh.source_document_id = prh.requisition_header_id
7527: and oeh.header_id = p_order_header_id
7528: and exists (select 'x'

Line 9771: FROM oe_order_headers_all oeh,

9767: PROCEDURE check_for_cancelled_order(p_repair_line_id NUMBER) IS
9768:
9769: CURSOR CANCELLED_ORDER_LINES(p_repair_line_id NUMBER) IS
9770: SELECT DISTINCT cpt.product_transaction_id PRODUCT_TXN_ID
9771: FROM oe_order_headers_all oeh,
9772: oe_order_lines_all oel,
9773: cs_estimate_details ced,
9774: csd_product_transactions cpt
9775: WHERE cpt.repair_line_id = p_repair_line_id