APPS.MSC_CL_ITEM_PULL dependencies on MTL_PARAMETERS

Line 1586: MTL_PARAMETERS org

1582: 1, --eam_item_type
1583: lv_item_name ,
1584: org.ORGANIZATION_CODE
1585: FROM msc_instance_orgs x,
1586: MTL_PARAMETERS org
1587: WHERE sr_instance_id= MSC_CL_PULL.v_instance_id
1588: and enabled_flag= 1
1589: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1590: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));

Line 1640: MTL_PARAMETERS org

1636: 2, --ATP_FLAG
1637: lv_item_name ,
1638: org.ORGANIZATION_CODE
1639: FROM msc_instance_orgs x,
1640: MTL_PARAMETERS org
1641: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1642: and x.enabled_flag= 1
1643: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1644: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));

Line 1707: lv_table_name:= 'MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;

1703: MSC_CL_PULL.v_instance_id ) ;
1704: commit ;
1705: END IF ;
1706:
1707: lv_table_name:= 'MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1708:
1709:
1710: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category
1711: where st_item_category.INVENTORY_ITEM_ID in ( -1000,-1001) and

Line 1739: lv_table_name :='MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;

1735: WHEN NO_DATA_FOUND THEN
1736: lv_category_id := -5001;
1737: END ;
1738:
1739: lv_table_name :='MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1740: lv_sql_stmt := 'insert into MSC_ST_ITEM_CATEGORIES ('
1741: ||'INVENTORY_ITEM_ID,'
1742: ||'ORGANIZATION_ID,'
1743: ||'SR_CATEGORY_SET_ID,'