DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on BOM_INVENTORY_COMPONENTS

Line 755: FROM bom_inventory_components bic --OKX_INV_COMPONENTS_V bic

751:
752: CURSOR c_war_items_csr (c_bill_seq_id NUMBER)
753: IS
754: SELECT bic.component_item_id war_item_id
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

Line 884: bom_inventory_components bic --okx_inv_components_v bic

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
888: AND bic.component_item_id = p_war_inv_item_id

Line 1012: From BOM_INVENTORY_COMPONENTS bic --OKX_INV_COMPONENTS_V bic

1008:
1009: /* fix for bug#6047047 -- fp of bug#5939487 */
1010: Cursor C_war_items_csr(C_bill_seq_id NUMBER) Is
1011: Select bic.component_item_id war_item_id,bic.effectivity_date,bic.disable_date
1012: From BOM_INVENTORY_COMPONENTS bic --OKX_INV_COMPONENTS_V bic
1013: Where bic.bill_sequence_id = C_bill_seq_id
1014: And exists
1015: (
1016: Select 'Component is a Warranty'