APPS.XDPSTATUS dependencies on XDP_ORDER_LINE_ITEMS

Line 1198: FROM xdp_order_line_items

1194: l_status_code VARCHAR2(30);
1195:
1196: CURSOR c_getlines(orderid NUMBER) IS
1197: SELECT status_code
1198: FROM xdp_order_line_items
1199: WHERE order_id = orderid ;
1200:
1201: BEGIN
1202:

Line 2137: FROM XDP_ORDER_LINE_ITEMS

2133: CURSOR c_GetLineStat(LineID number) IS
2134: SELECT Status_code,
2135: IS_VIRTUAL_LINE_FLAG,
2136: NVL(BUNDLE_ID,-999)
2137: FROM XDP_ORDER_LINE_ITEMS
2138: WHERE LINE_ITEM_ID = LineID;
2139: -- FOR UPDATE;
2140:
2141: CURSOR c_GetLineID IS

Line 2161: FROM XDP_ORDER_LINE_ITEMS

2157: AND LINE_RELATIONSHIP = 'IS_PART_OF_PACKAGE';
2158:
2159: CURSOR c_UpdatePackage(PackageLineID number) IS
2160: SELECT 1
2161: FROM XDP_ORDER_LINE_ITEMS
2162: WHERE LINE_ITEM_ID = PackageLineID;
2163: -- FOR UPDATE;
2164:
2165: CURSOR c_GetPackagedLineStatus(VirtualLine number) IS

Line 2169: XDP_ORDER_LINE_ITEMS XOL

2165: CURSOR c_GetPackagedLineStatus(VirtualLine number) IS
2166: SELECT XLR.RELATED_LINE_ITEM_ID,
2167: XOL.STATUS_CODE
2168: FROM XDP_LINE_RELATIONSHIPS XLR,
2169: XDP_ORDER_LINE_ITEMS XOL
2170: WHERE XLR.RELATED_LINE_ITEM_ID = (
2171: SELECT RELATED_LINE_ITEM_ID
2172: FROM XDP_LINE_RELATIONSHIPS
2173: WHERE LINE_ITEM_ID = VirtualLine)

Line 2179: FROM XDP_ORDER_LINE_ITEMS

2175: AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y';
2176:
2177: CURSOR c_GetBundledLines (LineItemID number, BundleID number) is
2178: SELECT LINE_ITEM_ID
2179: FROM XDP_ORDER_LINE_ITEMS
2180: WHERE LINE_ITEM_ID = LineItemID
2181: AND BUNDLE_ID = BundleID
2182: AND STATUS_CODE = 'ERROR';
2183:

Line 2316: from XDP_ORDER_LINE_ITEMS

2312: -- for update;
2313:
2314: cursor c_GetLines is
2315: select 1
2316: from XDP_ORDER_LINE_ITEMS
2317: where ORDER_ID = OrderID
2318: and STATUS_CODE = 'ERROR';
2319:
2320: l_OrderStatus varchar2(40);

Line 2436: UPDATE xdp_order_line_items

2432:
2433: BEGIN
2434: IF p_status IN ('IN PROGRESS','ERROR') THEN
2435:
2436: UPDATE xdp_order_line_items
2437: SET status_code = p_status ,
2438: last_update_date = sysdate,
2439: last_updated_by = fnd_global.user_id,
2440: last_update_login = fnd_global.login_id

Line 2443: UPDATE xdp_order_line_items

2439: last_updated_by = fnd_global.user_id,
2440: last_update_login = fnd_global.login_id
2441: WHERE line_item_id = p_line_item_id ;
2442: ELSE
2443: UPDATE xdp_order_line_items
2444: SET status_code = p_status ,
2445: completion_date = sysdate ,
2446: last_update_date = sysdate,
2447: last_updated_by = fnd_global.user_id,

Line 2545: FROM xdp_order_line_items oli

2541: SELECT 'Y'
2542: FROM xdp_order_headers oh
2543: WHERE order_id = p_order_id
2544: AND (EXISTS (SELECT 'Y'
2545: FROM xdp_order_line_items oli
2546: WHERE oli.order_id = oh.ordeR_id
2547: AND oli.status_code = 'ERROR' ) OR
2548: EXISTS (SELECT 'Y'
2549: FROM xdp_fulfill_worklist fw

Line 2582: FROM xdp_order_line_items

2578: is_virtual_line_flag,
2579: line_item_id,
2580: ib_source,
2581: ib_source_id
2582: FROM xdp_order_line_items
2583: WHERE line_item_id = p_lineitem_id ;
2584:
2585: CURSOR c_order_line IS
2586: SELECT 'Y'

Line 2587: FROM xdp_order_line_items oli

2583: WHERE line_item_id = p_lineitem_id ;
2584:
2585: CURSOR c_order_line IS
2586: SELECT 'Y'
2587: FROM xdp_order_line_items oli
2588: WHERE line_item_id = p_lineitem_id
2589: AND ( EXISTS (SELECT 'Y'
2590: FROM xdp_fulfill_worklist fw
2591: WHERE fw.line_item_id = oli.line_item_id

Line 2797: FROM xdp_order_line_items

2793: CURSOR c_lines IS
2794: SELECT is_package_flag , is_virtual_line_flag,
2795: line_item_id, status_code,
2796: ib_source, ib_source_id
2797: FROM xdp_order_line_items
2798: WHERE line_item_id = p_line_item_id;
2799:
2800: CURSOR c_pkg_child_lines( cv_line_item_id IN NUMBER) IS
2801: SELECT xoli.line_item_id, xoli.status_code

Line 2802: FROM xdp_line_relationships lr, xdp_order_line_items xoli

2798: WHERE line_item_id = p_line_item_id;
2799:
2800: CURSOR c_pkg_child_lines( cv_line_item_id IN NUMBER) IS
2801: SELECT xoli.line_item_id, xoli.status_code
2802: FROM xdp_line_relationships lr, xdp_order_line_items xoli
2803: WHERE lr.related_line_item_id = cv_line_item_id
2804: AND lr.line_item_id = xoli.line_item_id;
2805:
2806: CURSOR c_line_status (cv_line_item_id IN NUMBER) IS

Line 2891: FROM xdp_order_line_items

2887: WHERE order_id = p_order_id;
2888:
2889: CURSOR cur_lines IS
2890: SELECT status_code, line_item_id
2891: FROM xdp_order_line_items
2892: WHERE order_id = p_order_id;
2893:
2894: lv_status VARCHAR2(200);
2895: l_system_hold BOOLEAN := FALSE;