APPS.EGO_IMPORT_BATCHES_PKG dependencies on MTL_PARAMETERS

Line 415: FROM MTL_PARAMETERS MP

411: x_error_msg OUT NOCOPY VARCHAR2) IS
412:
413: Cursor Ego_Master_Org_Csr(v_organization_id IN NUMBER) IS
414: SELECT MP.ORGANIZATION_ID, MP.MASTER_ORGANIZATION_ID
415: FROM MTL_PARAMETERS MP
416: WHERE MP.ORGANIZATION_ID = v_organization_id;
417:
418: Cursor Ego_Source_System_Csr(v_source_system_code IN VARCHAR2) IS
419: SELECT SSM.ORIG_SYSTEM_ID

Line 461: FROM BOM_ALTERNATE_DESIGNATORS_VL b, mtl_parameters p

457: WHERE structure_type_name = 'All-Structure Types') QRSLT
458: WHERE ((ALTERNATE_DESIGNATOR_CODE = BOM_Globals.GET_PRIMARY_UI() OR
459: ALTERNATE_DESIGNATOR_CODE IN
460: (SELECT DISTINCT ALTERNATE_DESIGNATOR_CODE
461: FROM BOM_ALTERNATE_DESIGNATORS_VL b, mtl_parameters p
462: WHERE p.master_organization_id = v_master_org_id
463: AND b.ORGANIZATION_ID = p.organization_id)) AND
464: ((v_structure_type_id =
465: (Select Structure_Type_id

Line 537: FROM ENG_ENGINEERING_CHANGES EEC1, MTL_PARAMETERS mtp

533: (eec.approval_status_type = 3 AND
534: els.change_editable_flag = 'Y')))) QRSLT
535: WHERE (CHANGE_NOTICE IN
536: (SELECT CHANGE_NOTICE
537: FROM ENG_ENGINEERING_CHANGES EEC1, MTL_PARAMETERS mtp
538: WHERE EEC1.ORGANIZATION_ID = mtp.ORGANIZATION_ID
539: and mtp.MASTER_ORGANIZATION_ID = v_master_org_id) AND
540: (UPPER(CHANGE_MGMT_TYPE_CODE) =
541: UPPER(v_change_mgmt_type_code)))