eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPSTATUS dependencies on XDP_FULFILL_WORKLIST

Line 1805: FROM XDP_FULFILL_WORKLIST

1801:
1802: CURSOR c_GetWI(OrderID number, LineItemID number) IS
1803: SELECT STATUS_CODE,
1804: WORKITEM_INSTANCE_ID
1805: FROM XDP_FULFILL_WORKLIST
1806: WHERE ORDER_ID = OrderID
1807: AND LINE_ITEM_ID = LineItemID ;
1808:
1809: BEGIN

Line 2063: FROM XDP_FULFILL_WORKLIST

2059:
2060: IS
2061: CURSOR c_GetWIStat IS
2062: SELECT Status_code
2063: FROM XDP_FULFILL_WORKLIST
2064: WHERE WORKITEM_INSTANCE_ID = WorkitemInstanceID;
2065: -- FOR UPDATE;
2066:
2067: CURSOR c_GetFA IS

Line 2143: FROM XDP_FULFILL_WORKLIST

2139: -- FOR UPDATE;
2140:
2141: CURSOR c_GetLineID IS
2142: SELECT line_item_id
2143: FROM XDP_FULFILL_WORKLIST
2144: WHERE WOrkitem_instance_id = WorkitemInstanceID;
2145:
2146: CURSOR c_GetWI(LineID number) IS
2147: SELECT STATUS_CODE,

Line 2149: FROM XDP_FULFILL_WORKLIST

2145:
2146: CURSOR c_GetWI(LineID number) IS
2147: SELECT STATUS_CODE,
2148: WORKITEM_INSTANCE_ID
2149: FROM XDP_FULFILL_WORKLIST
2150: WHERE LINE_ITEM_ID = LineID
2151: AND STATUS_CODE = 'ERROR';
2152:
2153: CURSOR c_GetPackagedLines(VirtualLine number) IS

Line 2472: UPDATE xdp_fulfill_worklist

2468:
2469: BEGIN
2470: IF p_status IN ('IN PROGRESS','ERROR') THEN
2471:
2472: UPDATE xdp_fulfill_worklist
2473: SET status_code = p_status ,
2474: last_update_date = sysdate,
2475: last_updated_by = fnd_global.user_id,
2476: last_update_login = fnd_global.login_id

Line 2479: UPDATE xdp_fulfill_worklist

2475: last_updated_by = fnd_global.user_id,
2476: last_update_login = fnd_global.login_id
2477: WHERE workitem_instance_id = p_workitem_instance_id ;
2478: ELSE
2479: UPDATE xdp_fulfill_worklist
2480: SET status_code = p_status ,
2481: completion_date = sysdate ,
2482: last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,

Line 2549: FROM xdp_fulfill_worklist fw

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
2550: WHERE fw.order_id = oh.order_id
2551: AND fw.status_code = 'ERROR') OR
2552: EXISTS (SELECT 'Y'
2553: FROM xdp_fulfill_worklist fw,

Line 2553: FROM xdp_fulfill_worklist fw,

2549: FROM xdp_fulfill_worklist fw
2550: WHERE fw.order_id = oh.order_id
2551: AND fw.status_code = 'ERROR') OR
2552: EXISTS (SELECT 'Y'
2553: FROM xdp_fulfill_worklist fw,
2554: xdp_fa_runtime_list fr
2555: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2556: AND fw.order_id = oh.order_id
2557: AND fr.status_code = 'ERROR')) ;

Line 2590: FROM xdp_fulfill_worklist fw

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
2592: AND fw.status_code = 'ERROR') OR
2593: EXISTS (SELECT 'Y'
2594: FROM xdp_fulfill_worklist fw,

Line 2594: FROM xdp_fulfill_worklist fw,

2590: FROM xdp_fulfill_worklist fw
2591: WHERE fw.line_item_id = oli.line_item_id
2592: AND fw.status_code = 'ERROR') OR
2593: EXISTS (SELECT 'Y'
2594: FROM xdp_fulfill_worklist fw,
2595: xdp_fa_runtime_list fr
2596: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2597: AND fw.line_item_id = oli.line_item_id
2598: AND fr.status_code = 'ERROR')) ;

Line 2605: FROM xdp_fulfill_worklist fw

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
2607: AND fw.status_code = 'ERROR') OR
2608: EXISTS (SELECT 'Y'
2609: FROM xdp_fulfill_worklist fw,

Line 2609: FROM xdp_fulfill_worklist fw,

2605: FROM xdp_fulfill_worklist fw
2606: WHERE fw.line_item_id = lr.line_item_id
2607: AND fw.status_code = 'ERROR') OR
2608: EXISTS (SELECT 'Y'
2609: FROM xdp_fulfill_worklist fw,
2610: xdp_fa_runtime_list fr
2611: WHERE fw.workitem_instance_id = fr.workitem_instance_id
2612: AND fw.line_item_id = lr.line_item_id
2613: AND fr.status_code = 'ERROR')) ;

Line 2647: FROM xdp_fulfill_worklist fw

2643: l_status BOOLEAN := FALSE ;
2644:
2645: CURSOR c_order_line IS
2646: SELECT 'Y'
2647: FROM xdp_fulfill_worklist fw
2648: WHERE workitem_instance_id = p_WIInstance_id
2649: AND EXISTS (SELECT 'Y'
2650: FROM xdp_fa_runtime_list fr
2651: WHERE fr.workitem_instance_id = fw.workitem_instance_id

Line 2746: FROM xdp_fulfill_worklist

2742: FUNCTION GET_WI_STATUS(p_WIInstance_id IN NUMBER)
2743: RETURN VARCHAR2 IS
2744: cursor cur_wi_status is
2745: SELECT status_code
2746: FROM xdp_fulfill_worklist
2747: WHERE workitem_instance_id = p_WIInstance_id;
2748:
2749: cursor cur_fa_status is
2750: SELECT status_code

Line 2808: FROM xdp_fulfill_worklist

2804: AND lr.line_item_id = xoli.line_item_id;
2805:
2806: CURSOR c_line_status (cv_line_item_id IN NUMBER) IS
2807: SELECT workitem_instance_id
2808: FROM xdp_fulfill_worklist
2809: WHERE line_item_id = cv_line_item_id;
2810:
2811: l_line_status VARCHAR2(200);
2812: l_status VARCHAR2(200);