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_REFURBISH_IRO_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 309: -- Cancelled_Flag column in oe_order_headers_all table can have values 'Y', 'N' or Null ,

305: C_Action_Code_Defectives Constant Varchar2(30) := 'DEFECTIVES' ;
306: C_PROD_TXN_STATUS_BOOKED Constant Varchar2(30) := 'BOOKED' ;
307:
308:
309: -- Cancelled_Flag column in oe_order_headers_all table can have values 'Y', 'N' or Null ,
310: -- always consider 'N' or Null
311: -- Open_flag column in oe_order_headers_all table can have values 'Y', 'N' , always consider 'Y'
312: -- Booked_flag column in oe_order_headers_all table can have values 'Y', 'N', always consider 'Y'
313: -- Cancelled_Flag column in oe_order_lines_all table can have values 'Y', 'N' or Null ,

Line 311: -- Open_flag column in oe_order_headers_all table can have values 'Y', 'N' , always consider 'Y'

307:
308:
309: -- Cancelled_Flag column in oe_order_headers_all table can have values 'Y', 'N' or Null ,
310: -- always consider 'N' or Null
311: -- Open_flag column in oe_order_headers_all table can have values 'Y', 'N' , always consider 'Y'
312: -- Booked_flag column in oe_order_headers_all table can have values 'Y', 'N', always consider 'Y'
313: -- Cancelled_Flag column in oe_order_lines_all table can have values 'Y', 'N' or Null ,
314: -- always consider 'N' or Null
315: -- Open_flag column in oe_order_lines_all table can have values 'Y', 'N' , always consider 'Y'

Line 312: -- Booked_flag column in oe_order_headers_all table can have values 'Y', 'N', always consider 'Y'

308:
309: -- Cancelled_Flag column in oe_order_headers_all table can have values 'Y', 'N' or Null ,
310: -- always consider 'N' or Null
311: -- Open_flag column in oe_order_headers_all table can have values 'Y', 'N' , always consider 'Y'
312: -- Booked_flag column in oe_order_headers_all table can have values 'Y', 'N', always consider 'Y'
313: -- Cancelled_Flag column in oe_order_lines_all table can have values 'Y', 'N' or Null ,
314: -- always consider 'N' or Null
315: -- Open_flag column in oe_order_lines_all table can have values 'Y', 'N' , always consider 'Y'
316: -- Booked_flag column in oe_order_lines_all table can have values 'Y', 'N', always consider 'Y'

Line 343: From Oe_Order_Headers_All oeh,

339: oeh.transactional_curr_code currency_code,
340: prl.item_revision,
341: msi.serial_number_control_code,
342: msi.concatenated_segments
343: From Oe_Order_Headers_All oeh,
344: Oe_Order_Lines_all oel,
345: po_requisition_headers_all prh,
346: po_requisition_lines_all prl,
347: mtl_system_items_kfv msi

Line 409: From Oe_Order_Headers_All oeh,

405: prl.Requisition_Header_Id Req_Header_ID,
406: prl.Requisition_Line_ID Req_Line_Id,
407: msi.serial_number_control_code,
408: msi.concatenated_segments
409: From Oe_Order_Headers_All oeh,
410: Oe_Order_Lines_all oel,
411: hz_parties hp,
412: hz_cust_accounts hca,
413: po_requisition_headers_all prh,