DBA Data[Home] [Help]

APPS.OE_UPG_SO_NEW dependencies on SO_LINES_ALL

Line 815: so_lines_all sla,

811: sld.shippable_flag) shippable_flag,
812: sla.component_sort_code sort_order,
813: sla.terms_id
814: from
815: so_lines_all sla,
816: so_line_attributes slattr,
817: oe_upgrade_wsh_iface sld
818: /* so_line_details sld */
819: where

Line 826: (select NE.line_id from so_lines_all NE

822: decode(sla.item_type_code,'SERVICE',
823: nvl(sla.service_parent_line_id,0),sla.line_id) = sld.line_id(+) and
824: sla.line_type_code <> 'PARENT' and
825: not exists
826: (select NE.line_id from so_lines_all NE
827: where NE.line_Id = sla.service_parent_line_id
828: and NE.line_type_code = 'PARENT') /* Standalone service not upgraded */
829: order by
830: /* Bug #4681686, reshuffled the order by clause to make sure the at the Lines are pulled by

Line 1307: so_lines_all where

1303: begin
1304: -- 4234107 :shipped_quantity condition modified to have nvl check
1305: Select line_id into
1306: v_shipped_line_id from
1307: so_lines_all where
1308: header_id = g_line_rec.header_id and
1309: --shipped_quantity is not null and
1310: NVL(shipped_quantity,0) > 0 and
1311: ship_set_number = v_ship_set_number

Line 1481: FROM so_lines_all l,

1477: nvl(agr.invoicing_rule_id,
1478: nvl(g_invoicing_rule_id,NULL))))))
1479: INTO g_line_rec.accounting_rule_id,
1480: g_line_rec.invoicing_rule_id
1481: FROM so_lines_all l,
1482: so_agreements_b agr,
1483: ra_customer_trx_all ct,
1484: so_agreements_b comt,
1485: mtl_system_items si

Line 1599: from so_lines_all

1595: begin
1596: Select item_type_code, ato_flag,option_flag
1597: into r_original_item_type_code,
1598: r_ato_flag,r_option_flag
1599: from so_lines_all
1600: where line_id = mol.link_to_line_id;
1601: exception
1602: when others then
1603: null;

Line 1814: from so_lines_all

1810:
1811: IF v_return_lctr = 4 THEN
1812: Select max(line_number) + 1
1813: into g_line_rec.line_number
1814: from so_lines_all
1815: where header_id = G_HEADER_ID;
1816: END IF;
1817: else
1818: v_line_exit_flag := 1;

Line 2001: FROM so_lines_all

1997: r_shipment_number := mol.line_number;
1998:
1999: SELECT line_number
2000: INTO g_line_rec.line_number
2001: FROM so_lines_all
2002: WHERE line_id = (select shipment_schedule_line_id
2003: from so_lines_all
2004: where line_id = mol.line_id);
2005:

Line 2003: from so_lines_all

1999: SELECT line_number
2000: INTO g_line_rec.line_number
2001: FROM so_lines_all
2002: WHERE line_id = (select shipment_schedule_line_id
2003: from so_lines_all
2004: where line_id = mol.line_id);
2005:
2006: end if;
2007:

Line 2033: from so_lines_all

2029: -- check for ship_to on ATO model first
2030: if g_line_rec.ato_line_id <> g_line_rec.line_id then
2031: select ship_to_site_use_id
2032: into g_line_rec.ship_to_site_use_id
2033: from so_lines_all
2034: where line_id = g_line_rec.ato_line_id;
2035: end if;
2036: -- check for ship_to on top model next
2037: if g_line_rec.ship_to_site_use_id is null

Line 2041: from so_lines_all

2037: if g_line_rec.ship_to_site_use_id is null
2038: and g_line_rec.parent_line_id <> g_line_rec.line_id then
2039: select ship_to_site_use_id
2040: into g_line_rec.ship_to_site_use_id
2041: from so_lines_all
2042: where line_id = g_line_rec.parent_line_id;
2043: end if;
2044: end if;
2045:

Line 4933: from so_lines_all lines

4929: IS
4930:
4931: cursor model_lines IS
4932: select /*+ INDEX(SO_LINES_N1) */ lines.line_id
4933: from so_lines_all lines
4934: where lines.header_id = G_HEADER_ID
4935: and lines.item_type_code in ('MODEL','KIT')
4936: and parent_line_id is null
4937: and lines.line_type_code in ('REGULAR','DETAIL');

Line 4941: from so_lines_all

4937: and lines.line_type_code in ('REGULAR','DETAIL');
4938:
4939: cursor option_lines(p_parent_line_id IN NUMBER) IS
4940: select line_id,inventory_item_id,item_type_code
4941: from so_lines_all
4942: where parent_line_id=p_parent_line_id;
4943:
4944: cursor included_items(p_line_id IN NUMBER) IS
4945: select line_detail_id

Line 5278: from so_lines_all

5274: header_id = G_HEADER_ID;
5275:
5276: cursor service_product_lines (p_serviceable_line_id IN NUMBER) IS
5277: select line_id , service_parent_line_id
5278: from so_lines_all
5279: where service_parent_line_id = p_serviceable_line_id;
5280:
5281: cursor log_product_lines (p_service_parent_line_id IN NUMBER) IS
5282:

Line 5433: -- Get the equivalent records from so_lines_all

5429: END IF;
5430:
5431: BEGIN
5432:
5433: -- Get the equivalent records from so_lines_all
5434: l_serviceable_line_id := l_get_table(l_temp_index).line_id;
5435:
5436: OPEN service_product_lines (l_serviceable_line_id);
5437:

Line 5871: so_lines_all sla1, so_lines_all sla2, oe_upgrade_log upg,

5867: sla1.line_number,
5868: sla1.inventory_item_id,
5869: sla1.unit_code
5870: from
5871: so_lines_all sla1, so_lines_all sla2, oe_upgrade_log upg,
5872: oe_order_lines_all oeol
5873: where sla1.header_id = G_HEADER_ID
5874: and sla1.line_type_code = 'PARENT'
5875: and sla1.item_type_code in ('KIT','MODEL','STANDARD')

Line 5891: SO_LINES_ALL SLA

5887: INDEX(upg OE_UPGRADE_LOG_N6) index(sla SO_LINES_U1) */
5888: OOLA.LINE_ID,OOLA.LINE_NUMBER
5889: FROM OE_ORDER_LINES_ALL OOLA,
5890: OE_UPGRADE_LOG UPG ,
5891: SO_LINES_ALL SLA
5892: WHERE OOLA.HEADER_ID = G_HEADER_ID AND
5893: OOLA.LINE_ID = UPG.NEW_LINE_ID AND
5894: UPG.OLD_LINE_ID = SLA.LINE_ID AND
5895: SLA.SHIPMENT_SCHEDULE_LINE_ID = v_line_id

Line 5907: so_lines_all sla

5903: line_number,
5904: inventory_item_id,
5905: unit_code
5906: from
5907: so_lines_all sla
5908: where sla.header_id = G_HEADER_ID
5909: AND sla.line_type_code = 'REGULAR'
5910: AND item_type_code in ('KIT','MODEL','STANDARD')
5911: and parent_line_id is null -- To filter out options (included on Leena's instn.)

Line 8840: from so_lines_all

8836: where item_type_code <> 'SERVICE';
8837:
8838: cursor service_product_lines (p_serviceable_line_id IN NUMBER) IS
8839: select line_id , service_parent_line_id
8840: from so_lines_all
8841: where service_parent_line_id = p_serviceable_line_id;
8842:
8843: cursor log_product_lines (p_service_parent_line_id IN NUMBER) IS
8844:

Line 8882: -- Get the equivalent records from so_lines_all

8878:
8879: FETCH serviceable_lines into l_serviceable_line_id;
8880: EXIT WHEN serviceable_lines%NOTFOUND;
8881:
8882: -- Get the equivalent records from so_lines_all
8883: OPEN service_product_lines (l_serviceable_line_id);
8884:
8885: LOOP
8886: