[Home] [Help]
1670:
1671: IF l_ato_config_item_id is NOT NULL THEN
1672: SELECT line_id
1673: INTO l_ato_line_id
1674: FROM OE_ORDER_LINES_ALL OEOPT
1675: WHERE line_id =
1676: (SELECT line_id
1677: FROM oe_order_lines OEATO
1678: WHERE OEOPT.top_model_line_id = OEATO.top_model_line_id
1707: END IF;
1708:
1709: SELECT line_id
1710: INTO l_ato_line_id
1711: FROM OE_ORDER_LINES_ALL
1712: WHERE top_model_line_id = g_line_rec.top_model_line_id
1713: AND item_type_code = 'CLASS'
1714: AND component_code =
1715: SUBSTR( g_line_rec.component_code, 1,
1717: AND ato_line_id is not null
1718: AND open_flag = 'Y'
1719: AND component_code =
1720: ( SELECT MIN(OEMIN.component_code)
1721: FROM OE_ORDER_LINES_ALL OEMIN
1722: WHERE OEMIN.top_model_line_id
1723: = g_line_rec.top_model_line_id
1724: AND OEMIN.component_code =
1725: SUBSTR( g_line_rec.component_code, 1,
2338: THEN
2339:
2340: SELECT NVL(MAX(LINE_NUMBER)+1,1)
2341: INTO l_line_number
2342: FROM OE_ORDER_LINES_ALL
2343: WHERE HEADER_ID = g_line_rec.header_id;
2344:
2345: RETURN (l_line_number);
2346:
2797: l_inventory_item_id NUMBER := TO_NUMBER(p_return_attribute1);
2798:
2799: CURSOR C_REF_LINE(attr1 VARCHAR2, attr2 VARCHAR2) IS
2800: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2801: FROM oe_order_lines_all l,
2802: mtl_unit_transactions_all_v u,
2803: mtl_material_transactions m,
2804: oe_order_headers h
2805: WHERE l.Inventory_item_id = to_number(attr1)
2821: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2822: FROM mtl_material_transactions m,
2823: mtl_transaction_lot_val_v t,
2824: mtl_unit_transactions_all_v u,
2825: oe_order_lines_all l,
2826: oe_order_headers h
2827: WHERE u.Inventory_item_id = to_number(attr1)
2828: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2829: AND u.serial_number = attr2
2863: -- bug#5452691
2864:
2865: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2866: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2867: FROM oe_order_lines_all ool,
2868: oe_order_headers ooh,
2869: oe_transaction_types_tl ott
2870: WHERE ool.line_id = ord_line_id
2871: AND ooh.header_id = ool.header_id
2912: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
2913: INTO p_ref_line_id
2914: FROM ra_customer_trx_lines_all rctl,
2915: ra_customer_trx_all rct,
2916: oe_order_lines_all l,
2917: oe_order_headers h
2918: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
2919: and rctl.customer_trx_id = rct.customer_trx_id
2920: AND l.line_id = rctl.interface_line_attribute6
3875: and transaction_type_id = 33
3876: and trx_source_line_id = p_x_line_rec.reference_line_id
3877: and inventory_item_id = p_x_line_rec.inventory_item_id
3878: and organization_id = (select ship_from_org_id
3879: from oe_order_lines_all
3880: where line_id = p_x_line_rec.reference_line_id);
3881: Exception
3882: When No_Data_Found Then
3883: Null;
4447: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4448: OR g_line_rec.orig_sys_line_ref IS NULL)
4449: AND
4450: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4451: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4452: END IF;
4453:
4454: --{ bug3664313 FP start: added NULL check
4455: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR
5047: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5048: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5049: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5050: (g_multiple_shipments = 'YES') THEN
5051: p_x_line_rec.orig_sys_shipment_ref := 'OE_ORDER_LINES_ALL'||p_x_line_rec.line_id||'.'||'1';
5052: IF l_debug_level > 0 THEN
5053: oe_debug_pub.add( 'SHIP SYS = '||P_X_LINE_REC.ORIG_SYS_SHIPMENT_REF ) ;
5054: END IF;
5055: ELSE