APPS.MSC_CL_ITEM_PULL dependencies on MTL_PARAMETERS

Line 1618: MTL_PARAMETERS org

1614: 1, --eam_item_type
1615: lv_item_name ,
1616: org.ORGANIZATION_CODE
1617: FROM msc_instance_orgs x,
1618: MTL_PARAMETERS org
1619: WHERE sr_instance_id= MSC_CL_PULL.v_instance_id
1620: and enabled_flag= 1
1621: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1622: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));

Line 1673: MTL_PARAMETERS org

1669: 2, --ATP_FLAG
1670: lv_item_name ,
1671: org.ORGANIZATION_CODE
1672: FROM msc_instance_orgs x,
1673: MTL_PARAMETERS org
1674: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1675: and x.enabled_flag= 1
1676: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1677: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));

Line 1727: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '

1723: ||' 2, '
1724: ||' ''CMRO UMP'' , '
1725: ||' :V_ICODE||org.ORGANIZATION_CODE'
1726: ||' FROM msc_instance_orgs x, '
1727: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1728: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1729: ||' and x.enabled_flag= 1 '
1730: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1731: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

Line 1783: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '

1779: ||' 2, '
1780: ||' ''EAM Forecast'' , '
1781: ||' :V_ICODE||org.ORGANIZATION_CODE'
1782: ||' FROM msc_instance_orgs x, '
1783: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1784: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1785: ||' and x.enabled_flag= 1 '
1786: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1787: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

Line 1838: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '

1834: ||' 2, '
1835: ||' ''Maintenance'' , '
1836: ||' :V_ICODE||org.ORGANIZATION_CODE'
1837: ||' FROM msc_instance_orgs x, '
1838: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1839: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1840: ||' and x.enabled_flag= 1 '
1841: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1842: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

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

1903: MSC_CL_PULL.v_instance_id ) ;
1904: commit ;
1905: END IF ;
1906:
1907: lv_table_name:= 'MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1908:
1909:
1910: DELETE from MSC_ST_ITEM_CATEGORIES st_item_category
1911: where st_item_category.INVENTORY_ITEM_ID in ( -1000,-1001,-1002,-1003,-1004) and

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

1935: WHEN NO_DATA_FOUND THEN
1936: lv_category_id := -5001;
1937: END ;
1938:
1939: lv_table_name :='MTL_PARAMETERS'||MSC_CL_PULL.v_dblink;
1940: lv_sql_stmt := 'insert into MSC_ST_ITEM_CATEGORIES ('
1941: ||'INVENTORY_ITEM_ID,'
1942: ||'ORGANIZATION_ID,'
1943: ||'SR_CATEGORY_SET_ID,'