DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OE_SYS_PARAMETERS

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

1552: CURSOR csr_sell_item_exists(p_concatenated_segments VARCHAR2) IS
1553: select 'X'
1554: from MTL_SYSTEM_ITEMS_VL
1555: where organization_id =
1556: TO_NUMBER(oe_sys_parameters.value('MASTER_ORGANIZATION_ID', to_number(fnd_profile.value('ORG_ID'))))
1557: AND (bom_item_type = 1 OR bom_item_type = 4)
1558: AND vendor_warranty_flag = 'N'
1559: AND primary_uom_code <> 'ENR'
1560: AND concatenated_segments = p_concatenated_segments