DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on FND_PROFILE

Line 1485: TO_NUMBER(oe_sys_parameters.value('MASTER_ORGANIZATION_ID', to_number(fnd_profile.value('ORG_ID'))))

1481: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1482: select 'X'
1483: from MTL_SYSTEM_ITEMS_VL
1484: where organization_id =
1485: TO_NUMBER(oe_sys_parameters.value('MASTER_ORGANIZATION_ID', to_number(fnd_profile.value('ORG_ID'))))
1486: AND (bom_item_type = 1 OR bom_item_type = 4)
1487: AND vendor_warranty_flag = 'N'
1488: AND primary_uom_code <> 'ENR'
1489: AND concatenated_segments = p_concatenated_segments