[Home] [Help]
1736:
1737: IF l_ato_config_item_id is NOT NULL THEN
1738: SELECT line_id
1739: INTO l_ato_line_id
1740: FROM OE_ORDER_LINES_ALL OEOPT
1741: WHERE line_id =
1742: (SELECT line_id
1743: FROM oe_order_lines OEATO
1744: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id
1773: END IF;
1774:
1775: SELECT line_id
1776: INTO l_ato_line_id
1777: FROM OE_ORDER_LINES_ALL
1778: WHERE top_model_line_id = g_line_rec.top_model_line_id
1779: AND item_type_code = 'CLASS'
1780: AND component_code =
1781: SUBSTR( g_line_rec.component_code, 1,
1783: AND ato_line_id is not null
1784: AND open_flag = 'Y'
1785: AND component_code =
1786: ( SELECT MIN(OEMIN.component_code)
1787: FROM OE_ORDER_LINES_ALL OEMIN
1788: WHERE OEMIN.top_model_line_id
1789: = g_line_rec.top_model_line_id
1790: AND OEMIN.component_code =
1791: SUBSTR( g_line_rec.component_code, 1,
2455: THEN
2456:
2457: SELECT NVL(MAX(LINE_NUMBER)+1,1)
2458: INTO l_line_number
2459: FROM OE_ORDER_LINES_ALL
2460: WHERE HEADER_ID = g_line_rec.header_id;
2461:
2462: RETURN (l_line_number);
2463:
2916: l_inventory_item_id NUMBER := TO_NUMBER(p_return_attribute1);
2917:
2918: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2919: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2920: FROM oe_order_lines_all l,
2921: mtl_unit_transactions_all_v u,
2922: mtl_material_transactions m,
2923: oe_order_headers h
2924: WHERE l.Inventory_item_id = to_number(attr1)
2940: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2941: FROM mtl_material_transactions m,
2942: mtl_transaction_lot_val_v t,
2943: mtl_unit_transactions_all_v u,
2944: oe_order_lines_all l,
2945: oe_order_headers h
2946: WHERE u.Inventory_item_id = to_number(attr1)
2947: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2948: AND u.serial_number = attr2
2982: -- bug#5452691
2983:
2984: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2985: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2986: FROM oe_order_lines_all ool,
2987: oe_order_headers ooh,
2988: oe_transaction_types_tl ott
2989: WHERE ool.line_id = ord_line_id
2990: AND ooh.header_id = ool.header_id
3031: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
3032: INTO p_ref_line_id
3033: FROM ra_customer_trx_lines_all rctl,
3034: ra_customer_trx_all rct,
3035: oe_order_lines_all l,
3036: oe_order_headers h
3037: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
3038: and rctl.customer_trx_id = rct.customer_trx_id
3039: AND l.line_id = rctl.interface_line_attribute6
4002: and transaction_type_id = 33
4003: and trx_source_line_id = p_x_line_rec.reference_line_id
4004: and inventory_item_id = p_x_line_rec.inventory_item_id
4005: and organization_id = (select ship_from_org_id
4006: from oe_order_lines_all
4007: where line_id = p_x_line_rec.reference_line_id);
4008: Exception
4009: When No_Data_Found Then
4010: Null;
4597: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4598: OR g_line_rec.orig_sys_line_ref IS NULL)
4599: AND
4600: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4601: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4602: END IF;
4603:
4604: --{ bug3664313 FP start: added NULL check
4605: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR
5228: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5229: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5230: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5231: (g_multiple_shipments = 'YES') THEN
5232: p_x_line_rec.orig_sys_shipment_ref := 'OE_ORDER_LINES_ALL'||p_x_line_rec.line_id||'.'||'1';
5233: IF l_debug_level > 0 THEN
5234: oe_debug_pub.add( 'SHIP SYS = '||P_X_LINE_REC.ORIG_SYS_SHIPMENT_REF ) ;
5235: END IF;
5236: ELSE