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_VL

Line 107: FROM OKE_K_DELIVERABLES_VL D

103: , D.DESCRIPTION
104: , H.K_TYPE
105: , W.WF_ITEM_TYPE
106: , W.WF_PROCESS
107: FROM OKE_K_DELIVERABLES_VL D
108: , OKE_WORKFLOWS W
109: , OKC_K_HEADERS_B B
110: , OKE_K_HEADERS_FULL_V H
111: , OKC_K_LINES_B S

Line 868: FROM OKE_K_DELIVERABLES_VL

864: ,DESCRIPTION
865: INTO L_Delivery_Date
866: ,L_Deliverable_Num
867: ,L_Description
868: FROM OKE_K_DELIVERABLES_VL
869: WHERE DELIVERABLE_ID=L_Deliverable_ID;
870: EXCEPTION
871: WHEN OTHERS THEN
872: NULL;

Line 1005: FROM OKE_K_DELIVERABLES_VL

1001: ,l_uom_code
1002: ,l_ship_to_location_id
1003: ,l_ship_from_location_id
1004: ,l_expected_date
1005: FROM OKE_K_DELIVERABLES_VL
1006: WHERE DELIVERABLE_ID=L_Deliverable_ID;
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: NULL;

Line 1038: FROM OKE_K_DELIVERABLES_VL

1034: SELECT K_HEADER_ID
1035: ,K_LINE_ID
1036: INTO L_K_HEADER_ID
1037: ,L_K_LINE_ID
1038: FROM OKE_K_DELIVERABLES_VL
1039: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: ResultOut := 'ERROR:';

Line 1166: FROM OKE_K_DELIVERABLES_VL

1162: ,l_ndb_schedule_designator
1163: ,l_quantity
1164: ,l_uom_code
1165: ,l_expected_date
1166: FROM OKE_K_DELIVERABLES_VL
1167: WHERE DELIVERABLE_ID=L_Deliverable_ID;
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: NULL;

Line 1198: FROM OKE_K_DELIVERABLES_VL

1194: SELECT K_HEADER_ID
1195: ,K_LINE_ID
1196: INTO L_K_HEADER_ID
1197: ,L_K_LINE_ID
1198: FROM OKE_K_DELIVERABLES_VL
1199: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: ResultOut := 'ERROR:';

Line 1305: FROM OKE_K_DELIVERABLES_VL

1301:
1302: BEGIN
1303: SELECT READY_TO_PROCURE
1304: INTO L_Ready_To_Procure
1305: FROM OKE_K_DELIVERABLES_VL
1306: WHERE DELIVERABLE_ID=L_Deliverable_ID;
1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: NULL;

Line 1330: FROM OKE_K_DELIVERABLES_VL

1326: SELECT K_HEADER_ID
1327: ,K_LINE_ID
1328: INTO L_K_HEADER_ID
1329: ,L_K_LINE_ID
1330: FROM OKE_K_DELIVERABLES_VL
1331: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: ResultOut := 'ERROR:';

Line 2043: FROM OKE_K_DELIVERABLES_VL

2039:
2040: BEGIN
2041: SELECT COMPLETED_FLAG
2042: INTO L_Completed_Flag
2043: FROM OKE_K_DELIVERABLES_VL
2044: WHERE DELIVERABLE_ID=L_Deliverable_ID;
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: NULL;