DBA Data[Home] [Help]

APPS.CSD_REFURBISH_IRO_GRP dependencies on OE_ORDER_LINES_ALL

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

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'
317: -- Party information, bill-to-address and ship-to-address are picked from ISO2 Bug # 3389067

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

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'
317: -- Party information, bill-to-address and ship-to-address are picked from ISO2 Bug # 3389067
318: Cursor Get_SRandRO_from_IRandISO_IN (p_ISO_Header_Id_IN Number, p_Req_Header_Id_IN Number ) IS
319: Select oeh.order_number order_number,

Line 316: -- Booked_flag column in oe_order_lines_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'
317: -- Party information, bill-to-address and ship-to-address are picked from ISO2 Bug # 3389067
318: Cursor Get_SRandRO_from_IRandISO_IN (p_ISO_Header_Id_IN Number, p_Req_Header_Id_IN Number ) IS
319: Select oeh.order_number order_number,
320: oeh.header_id order_header_id,

Line 344: Oe_Order_Lines_all oel,

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
348: Where oeh.header_id = p_ISO_Header_Id_IN

Line 410: Oe_Order_Lines_all oel,

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,
414: po_requisition_lines_all prl,