APPS.XDPSTATUS dependencies on XDP_LINE_RELATIONSHIPS

Line 2155: FROM XDP_LINE_RELATIONSHIPS

2151: AND STATUS_CODE = 'ERROR';
2152:
2153: CURSOR c_GetPackagedLines(VirtualLine number) IS
2154: SELECT RELATED_LINE_ITEM_ID
2155: FROM XDP_LINE_RELATIONSHIPS
2156: WHERE LINE_ITEM_ID = VirtualLine
2157: AND LINE_RELATIONSHIP = 'IS_PART_OF_PACKAGE';
2158:
2159: CURSOR c_UpdatePackage(PackageLineID number) IS

Line 2168: FROM XDP_LINE_RELATIONSHIPS XLR,

2164:
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

Line 2172: FROM XDP_LINE_RELATIONSHIPS

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)
2174: AND XLR.LINE_ITEM_ID = XOL.LINE_ITEM_ID
2175: AND XOL.IS_VIRTUAL_LINE_FLAG = 'Y';
2176:

Line 2602: FROM xdp_line_relationships lr

2598: AND fr.status_code = 'ERROR')) ;
2599:
2600: CURSOR c_order_pkg_line(lv_line_item_id IN NUMBER) IS
2601: SELECT 'Y'
2602: FROM xdp_line_relationships lr
2603: WHERE lr.related_line_item_id = lv_line_item_id
2604: AND (EXISTS (SELECT 'Y'
2605: FROM xdp_fulfill_worklist fw
2606: WHERE fw.line_item_id = lr.line_item_id

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