APPS.INVPVDR6 dependencies on MTL_PARAMETERS

Line 331: from mtl_parameters

327: if cr.UNIT_OF_ISSUE is not null then
328: begin
329: select master_organization_id
330: into masterorg_id
331: from mtl_parameters
332: where organization_id = cr.organization_id ;
333:
334: if (cr.transaction_type = 'CREATE') then
335: if (masterorg_id = cr.organization_id) then

Line 384: instead of mtl_parameters to validate the source org, since

380: -- validate foreign keys
381: if cr.SOURCE_ORGANIZATION_ID is not null then
382: begin
383: /* Fix for bug 5844510-Use org_organization_definitions view
384: instead of mtl_parameters to validate the source org, since
385: an organization's disable date can be obtained from ood view.
386: select 'x' into temp
387: from MTL_PARAMETERS
388: where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID;

Line 387: from MTL_PARAMETERS

383: /* Fix for bug 5844510-Use org_organization_definitions view
384: instead of mtl_parameters to validate the source org, since
385: an organization's disable date can be obtained from ood view.
386: select 'x' into temp
387: from MTL_PARAMETERS
388: where ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID;
389: */
390: select 'x' into temp
391: from org_organization_definitions

Line 421: from MTL_PARAMETERS

417: -- validate foreign keys
418: if cr.DEFAULT_SHIPPING_ORG is not null then
419: begin
420: select 'x' into temp
421: from MTL_PARAMETERS
422: where ORGANIZATION_ID = cr.DEFAULT_SHIPPING_ORG;
423: exception
424: when NO_DATA_FOUND then
425: dumm_status := INVPUOPI.mtl_log_interface_err(