DBA Data[Home] [Help]

APPS.XNP_WF_SYNC dependencies on XDP_ORDER_LINE_ITEMS

Line 439: FROM xdp_order_line_items

435: -- Used to derive SYNC_LABEL, and No Path
436:
437: CURSOR lv_line_item_cur (cv_order_id IN NUMBER) IS
438: SELECT order_id, line_item_name,count(*) range_count
439: FROM xdp_order_line_items
440: WHERE order_id = cv_order_id
441: GROUP BY order_id,line_item_name;
442:
443: -- Cursor to get all Line Item ID's within an Order

Line 448: FROM xdp_order_line_items

444: -- based on the SYNC_LABEL
445:
446: CURSOR lv_line_item_id_cur (cv_order_id IN NUMBER, cv_line_item_name IN VARCHAR2) IS
447: SELECT line_item_id
448: FROM xdp_order_line_items
449: WHERE order_id = cv_order_id
450: AND line_item_name = cv_line_item_name;
451:
452: BEGIN