DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 759: FROM okx_system_items_v mtl

755: FROM bom_inventory_components bic --OKX_INV_COMPONENTS_V bic
756: WHERE bic.bill_sequence_id = c_bill_seq_id
757: AND EXISTS (
758: SELECT 'Component is a Warranty'
759: FROM okx_system_items_v mtl
760: WHERE mtl.id2 = okc_context.get_okc_organization_id
761: AND mtl.id1 = bic.component_item_id
762: AND mtl.vendor_warranty_flag = 'Y')
763: AND TRUNC (p_datec) >= TRUNC (bic.effectivity_date)

Line 883: FROM mtl_system_items_b_kfv b, --okx_system_items_v mtl,

879: CURSOR bom_dtls_csr
880: IS
881: SELECT bic.component_quantity, b.primary_uom_code,
882: b.coverage_schedule_id coverage_template_id
883: FROM mtl_system_items_b_kfv b, --okx_system_items_v mtl,
884: bom_inventory_components bic --okx_inv_components_v bic
885: WHERE bic.component_item_id = b.inventory_item_id
886: AND b.organization_id = okc_context.get_okc_organization_id
887: AND bic.bill_sequence_id = p_comm_bill_seq_id

Line 1017: From OKX_SYSTEM_ITEMS_V mtl

1013: Where bic.bill_sequence_id = C_bill_seq_id
1014: And exists
1015: (
1016: Select 'Component is a Warranty'
1017: From OKX_SYSTEM_ITEMS_V mtl
1018: Where mtl.id2 = okc_context.get_okc_organization_id
1019: And mtl.id1 = bic.component_item_id
1020: And mtl.vendor_warranty_flag = 'Y'
1021: )

Line 2924: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V

2920: WHERE okl.ID = p_line_id AND okl.cle_id IS NOT NULL);
2921:
2922: /*Cursor l_serv_Csr(p_serv_id NUMBER) is
2923: Select COVERAGE_SCHEDULE_ID coverage_template_id
2924: From MTL_SYSTEM_ITEMS_B_KFV -- OKX_SYSTEM_ITEMS_V
2925: WHere INVENTORY_ITEM_ID = p_serv_id;
2926: */
2927: CURSOR l_serv_csr (p_serv_id NUMBER)
2928: IS

Line 3573: FROM okx_system_items_v

3569:
3570: CURSOR get_ship_csr
3571: IS
3572: SELECT shippable_item_flag, service_starting_delay
3573: FROM okx_system_items_v
3574: WHERE id1 = p_prod_item_id
3575: AND organization_id = okc_context.get_okc_organization_id;
3576: BEGIN
3577: okc_context.set_okc_org_context (p_org_id => p_org_id,

Line 3727: mtl_system_items_tl t --okx_system_items_v mtl

3723: b.coverage_schedule_id coverage_template_id
3724: -- mtl.coverage_template_id
3725: FROM csi_item_instances csi,
3726: mtl_system_items_b_kfv b,
3727: mtl_system_items_tl t --okx_system_items_v mtl
3728: WHERE csi.instance_id = p_cpid
3729: AND csi.inventory_item_id = b.inventory_item_id
3730: AND b.inventory_item_id = t.inventory_item_id
3731: AND b.organization_id = t.organization_id