[Home] [Help]
173: /********************************************************************
174: * Function : Organization
175: * Returns : NUMBER
176: * Purpose : Will convert the value of organization_code to
177: * organization_id using MTL_PARAMETERS.
178: * If the conversion fails then the function will return
179: * a NULL otherwise will return the org_id.
180: * For an unexpected error function will return a
181: * missing value.
186: l_id NUMBER;
187: BEGIN
188: SELECT Organization_Id
189: INTO l_id
190: FROM Mtl_Parameters
191: WHERE Organization_Code = p_organization;
192:
193: RETURN l_id;
194:
721: BMI.Alternate_Bom_Designator IS NOT NULL
722: AND NOT EXISTS
723: (SELECT NULL FROM Bom_structures_b bsb
724: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
725: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
726: AND bsb.Alternate_Bom_Designator IS NULL
727: );
728:
729:
895: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
896: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK2_VALUE = ';
897: l_dyn_sql := l_dyn_sql || ' ( ';
898: l_dyn_sql := l_dyn_sql || ' SELECT ORGANIZATION_ID ';
899: l_dyn_sql := l_dyn_sql || ' FROM MTL_PARAMETERS ';
900: l_dyn_sql := l_dyn_sql || ' WHERE ORGANIZATION_CODE =EBI.'|| G_INTF_ORG_CODE;
901: l_dyn_sql := l_dyn_sql || ' ) ';
902: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
903: l_dyn_sql := l_dyn_sql || ' AND PROCESS_STATUS = 1 ';
2510: l_str_type_id,
2511: 'SYNC',
2512: l_usr_attr_data_tbl(i).COMPONENT_ITEM_NUMBER,
2513: l_usr_attr_data_tbl(i).ORGANIZATION_CODE,
2514: (SELECT ORGANIZATION_ID FROM mtl_parameters where organization_code = l_usr_attr_data_tbl(i).ORGANIZATION_CODE),
2515: l_usr_attr_data_tbl(i).ASSEMBLY_ITEM_NUMBER,
2516: l_usr_attr_data_tbl(i).PARENT_SOURCE_SYSTEM_REFERENCE
2517: );
2518: