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.OKE_DTS_WORKFLOW dependencies on OKE_K_DELIVERABLES_B

Line 275: update oke_k_deliverables_b

271: --
272: WF_ENGINE.StartProcess( ItemType => L_WF_Item_Type
273: , ItemKey => L_WF_Item_Key );
274:
275: update oke_k_deliverables_b
276: set wf_item_key = L_WF_Item_Key
277: where deliverable_id = P_DELIVERABLE_ID
278: ;
279:

Line 1463: From oke_k_deliverables_b d

1459: , D.Mps_Transaction_Id
1460: , D.Ship_From_Org_Id
1461: , D.Ship_To_Org_Id
1462: , D.Direction
1463: From oke_k_deliverables_b d
1464: , pa_projects_all p
1465: , pa_tasks t
1466: , oke_system_items_v i
1467: , oke_k_headers h

Line 1669: From oke_k_deliverables_b d

1665: , D.Mps_Transaction_Id
1666: , D.Ship_From_Org_Id
1667: , D.Ship_To_Org_Id
1668: , D.Direction
1669: From oke_k_deliverables_b d
1670: , pa_projects_all p
1671: , pa_tasks t
1672: , oke_system_items_v i
1673: , oke_k_headers h

Line 1873: From oke_k_deliverables_b d

1869: , D.Mps_Transaction_Id
1870: , D.Ship_From_Org_Id
1871: , D.Ship_To_Org_Id
1872: , D.Direction
1873: From oke_k_deliverables_b d
1874: , pa_projects_all p
1875: , pa_tasks t
1876: , oke_system_items_v i
1877: , oke_k_headers h

Line 2107: FROM OKE_K_DELIVERABLES_B

2103: l_ship_to_location_id NUMBER;
2104:
2105: CURSOR L IS
2106: SELECT SHIP_TO_LOCATION_ID
2107: FROM OKE_K_DELIVERABLES_B
2108: WHERE Deliverable_ID = L_Deliverable_ID;
2109:
2110: CURSOR C IS
2111: SELECT PO_Ref_1

Line 2112: FROM OKE_K_DELIVERABLES_B

2108: WHERE Deliverable_ID = L_Deliverable_ID;
2109:
2110: CURSOR C IS
2111: SELECT PO_Ref_1
2112: FROM OKE_K_DELIVERABLES_B
2113: WHERE Deliverable_ID = L_Deliverable_ID
2114: AND NOT EXISTS ( SELECT 1
2115: FROM po_requisitions_interface_all
2116: WHERE deliver_to_location_id = l_ship_to_location_id

Line 2190: FROM OKE_K_DELIVERABLES_B

2186: L_Action VARCHAR2(25);
2187:
2188: CURSOR C IS
2189: SELECT Shipping_Request_ID
2190: FROM OKE_K_DELIVERABLES_B
2191: WHERE Deliverable_ID = L_Deliverable_ID;
2192:
2193: BEGIN
2194: IF ( FuncMode = 'RUN' ) THEN

Line 2258: FROM OKE_K_DELIVERABLES_B

2254: L_Action VARCHAR2(25);
2255:
2256: CURSOR C IS
2257: SELECT Mps_Transaction_ID
2258: FROM OKE_K_DELIVERABLES_B
2259: WHERE Deliverable_ID = L_Deliverable_ID;
2260:
2261: BEGIN
2262: IF ( FuncMode = 'RUN' ) THEN

Line 2321: FROM OKE_K_DELIVERABLES_B

2317: L_WF_Item_Key VARCHAR2(240);
2318:
2319: CURSOR C IS
2320: SELECT WF_ITEM_KEY
2321: FROM OKE_K_DELIVERABLES_B
2322: WHERE Deliverable_ID = P_Deliverable_ID;
2323:
2324: BEGIN
2325: OPEN C;