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_INTEGRATION_PKG dependencies on OKE_K_DELIVERABLES_B

Line 307: From oke_k_deliverables_b

303: , Quantity
304: , Project_Id
305: , Task_Id
306: , Unit_Number
307: From oke_k_deliverables_b
308: Where Deliverable_Id = P_Deliverable_Id;
309:
310: recinfo l_csr%ROWTYPE;
311: cinfo C%ROWTYPE;

Line 396: From oke_k_deliverables_b

392: , task_id
393: , unit_number
394: , uom_code
395: , mps_transaction_id
396: From oke_k_deliverables_b
397: Where deliverable_id = p_deliverable_id
398: FOR UPDATE NOWAIT;
399: L_DRow_ID ROWID;
400: L_Item_ID NUMBER;

Line 506: UPDATE oke_k_deliverables_b

502: -- AND Organization_Id = L_Inv_Org_ID_Old
503: -- );
504: END IF;
505:
506: UPDATE oke_k_deliverables_b
507: SET po_ref_2 = 1
508: WHERE ROWID = L_DRow_ID;
509:
510: ELSE -- if record wasn't updated - insert it

Line 528: UPDATE oke_k_deliverables_b

524: );
525: IF l_mps_transaction_id IS NOT NULL THEN
526: x_out_id := l_mps_transaction_id;
527: -- update mps_transaction_id in deliverable table
528: UPDATE oke_k_deliverables_b
529: SET mps_transaction_id = l_mps_transaction_id
530: WHERE ROWID = L_DRow_ID;
531: END IF;
532: END IF;

Line 627: from oke_k_deliverables_b d

623: ( C_deliverable_id number
624: , C_term_code varchar2
625: ) is
626: select kt1.term_value_pk1 term_value
627: from oke_k_deliverables_b d
628: , oke_k_terms kt1
629: , ( select cle_id , cle_id_ascendant , level_sequence from okc_ancestrys
630: union all
631: select id , id , 99999 from okc_k_lines_b ) a

Line 642: FROM oke_k_deliverables_b

638: order by decode(kt1.k_line_id , null , 0 , a.level_sequence) desc;
639:
640: CURSOR csr_dts_ship(p_id number) IS
641: SELECT shipping_request_id, in_process_flag, initiate_shipment_date
642: FROM oke_k_deliverables_b
643: WHERE deliverable_id = p_id
644: FOR UPDATE OF shipping_request_id, in_process_flag, initiate_shipment_date NOWAIT;
645:
646: CURSOR l_line_csr(p_id number) IS

Line 672: , OKE_K_DELIVERABLES_B B

668: , B.WEIGHT_UOM_CODE
669: , B.VOLUME
670: , B.VOLUME_UOM_CODE
671: FROM OKC_K_HEADERS_B H
672: , OKE_K_DELIVERABLES_B B
673: , OKE_K_DELIVERABLES_TL T
674: WHERE B.DELIVERABLE_ID = p_id
675: AND B.DELIVERABLE_ID = T.DELIVERABLE_ID
676: AND T.LANGUAGE = USERENV('LANG')

Line 931: update oke_k_deliverables_b

927: WSH_interface_pub.create_shipment_lines(l_ship_rec, l_id, l_return_status);
928:
929: if l_return_status = oke_api.g_ret_sts_success then
930: -- update deliverable table
931: update oke_k_deliverables_b
932: set shipping_request_id = l_id,
933: in_process_flag = 'Y',
934: initiate_shipment_date = sysdate
935: where CURRENT OF csr_dts_ship;

Line 1077: FROM oke_k_deliverables_b

1073: where deliverable_id = p_deliverable_id;
1074:
1075: CURSOR csr_dts_req(p_id number) IS
1076: SELECT po_ref_1, in_process_flag
1077: FROM oke_k_deliverables_b
1078: WHERE deliverable_id = p_id
1079: FOR UPDATE OF po_ref_1, in_process_flag NOWAIT;
1080: /* Bug Number: 6011322 start */
1081: cursor req_c(p_id number, p_batch_id number) is

Line 1184: WHERE ID = (SELECT K_Header_ID FROM oke_k_deliverables_b WHERE Deliverable_ID = P_Deliverable_ID);

1180:
1181: CURSOR Header_C IS
1182: SELECT Buy_Or_Sell
1183: FROM okc_k_headers_b
1184: WHERE ID = (SELECT K_Header_ID FROM oke_k_deliverables_b WHERE Deliverable_ID = P_Deliverable_ID);
1185:
1186: BEGIN
1187: l_return_status := OKE_API.START_ACTIVITY(
1188: l_api_name,

Line 1460: from oke_k_deliverables_b d

1456: l_vendor_site_id,
1457: l_req_line_type_id,
1458: l_category_id,
1459: l_item_description
1460: from oke_k_deliverables_b d
1461: , okc_k_headers_b h
1462: , mtl_parameters mp
1463: , org_organization_definitions ood
1464: , oke_k_vers_numbers_v ver

Line 1479: update oke_k_deliverables_b

1475: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Req created successfully, update deliverable table');
1476: END IF;
1477:
1478: -- update deliverable table
1479: update oke_k_deliverables_b
1480: set po_ref_1 = l_id
1481: , in_process_flag = 'Y'
1482: where CURRENT OF csr_dts_req;
1483:

Line 1727: --bug 7390122 changed oke_k_deliverables_b to oke_k_deliverables_vl as it has description

1723: , L.line_number line_number
1724: , D.deliverable_num deliverable_num
1725: , D.description description
1726: , h.authoring_org_id org_id
1727: --bug 7390122 changed oke_k_deliverables_b to oke_k_deliverables_vl as it has description
1728: FROM oke_k_deliverables_vl D
1729: , okc_k_lines_b L
1730: , oke_k_headers_v H
1731: , oke_k_types_vl T

Line 1744: FROM oke_k_deliverables_b D

1740: , D.expenditure_type
1741: , D.expenditure_item_date
1742: , O.name expenditure_org
1743: , D.need_by_date
1744: FROM oke_k_deliverables_b D
1745: , hr_all_organization_units_tl O
1746: WHERE D.deliverable_id = p_id
1747: AND O.organization_id (+) = D.expenditure_organization_id
1748: AND O.language (+) = userenv('LANG');

Line 1754: FROM oke_k_deliverables_b D

1750:
1751: CURSOR c_ship (p_id number) IS
1752: SELECT D.ship_from_location_id
1753: , L.location_code ship_from_location
1754: FROM oke_k_deliverables_b D
1755: , hr_locations_all_tl L
1756: WHERE D.deliverable_id = p_id
1757: AND L.location_id = D.ship_from_location_id
1758: AND L.language = userenv('LANG');

Line 2527: FROM oke_k_deliverables_b

2523: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
2524:
2525: CURSOR dlvbl_c IS
2526: SELECT k_header_id, uom_code, shipping_request_id
2527: FROM oke_k_deliverables_b
2528: where deliverable_id = p_deliverable_id;
2529:
2530: CURSOR cancel_qty_c IS
2531: SELECT Nvl(Sum(CANCELLED_QUANTITY),0)