DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on MTL_PARAMETERS

Line 278: From MTL_PARAMETERS

274: -- Get the Master Organization ID
275: Begin
276: Select master_organization_id
277: Into v_mast_org_id
278: From MTL_PARAMETERS
279: Where organization_id = organization_id_mig(i);
280: Exception
281: When no_data_found Then
282: Raise Process_next;

Line 586: FROM mtl_parameters mp,

582: AND msi.serial_number_control_code IN (2,5)
583: AND msn.current_status = 3
584: AND EXISTS (
585: SELECT '1'
586: FROM mtl_parameters mp,
587: mtl_system_items msi_mast
588: WHERE mp.organization_id = msi.organization_id
589: AND msi_mast.inventory_item_id = msi.inventory_item_id
590: AND msi_mast.organization_id = mp.master_organization_id)

Line 732: FROM MTL_PARAMETERS

728: -- Get the Master Organization ID
729: BEGIN
730: SELECT master_organization_id
731: INTO v_mast_org_id
732: FROM MTL_PARAMETERS
733: WHERE organization_id = srl_rec.organization_id;
734: EXCEPTION
735: WHEN no_data_found THEN
736: RAISE Skip_serial;