eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 409: mtl_secondary_inventories m,

405: FROM mtl_categories b,
406: mtl_item_categories a,
407: mtl_system_items_vl c,
408: mtl_parameters p,
409: mtl_secondary_inventories m,
410: mtl_item_sub_inventories s
411: WHERE b.category_id = a.category_id
412: AND b.structure_id = :mcat_struct_id
413: AND c.inventory_item_flag = ''Y''

Line 566: mtl_secondary_inventories m,

562: FROM mtl_categories b,
563: mtl_item_categories a,
564: mtl_system_items_vl c,
565: mtl_parameters p,
566: mtl_secondary_inventories m,
567: mtl_item_sub_inventories s,
568: per_all_people_f v
569: WHERE b.category_id = a.category_id
570: AND b.structure_id = :mcat_struct_id

Line 1060: FROM mtl_secondary_inventories sub1

1056: OR (sup.from_organization_id = :l_org_id
1057: AND ((:l_include_nonnet = 2
1058: AND
1059: EXISTS (SELECT ''x''
1060: FROM mtl_secondary_inventories sub1
1061: WHERE sub1.organization_id = sup.from_organization_id
1062: AND sub1.secondary_inventory_name = sup.from_subinventory
1063: AND sub1.availability_type <> 1
1064: )

Line 1073: FROM mtl_secondary_inventories sub2

1069: )
1070: AND (sup.to_subinventory IS NULL
1071: OR
1072: (EXISTS (SELECT ''x''
1073: FROM mtl_secondary_inventories sub2
1074: WHERE sub2.secondary_inventory_name = sup.to_subinventory
1075: AND sub2.organization_id = sup.to_organization_id
1076: AND sub2.availability_type = decode(:l_include_nonnet,
1077: 1,sub2.availability_type,

Line 1346: FROM mtl_secondary_inventories sub1

1342: AND (NVL(source_organization_id,-1) <> p_org_id OR
1343: (source_organization_id = p_org_id AND
1344: (( p_include_nonnet = 2 AND
1345: EXISTS (SELECT 'x'
1346: FROM mtl_secondary_inventories sub1
1347: WHERE sub1.organization_id = source_organization_id
1348: AND sub1.secondary_inventory_name = source_subinventory
1349: AND sub1.availability_type <> 1)) OR
1350: p_level = 2)

Line 1354: FROM mtl_secondary_inventories sub2

1350: p_level = 2)
1351: ))
1352: AND (destination_subinventory IS NULL OR
1353: EXISTS (SELECT 1
1354: FROM mtl_secondary_inventories sub2
1355: WHERE secondary_inventory_name = destination_subinventory
1356: AND destination_subinventory = NVL(p_subinv,
1357: destination_subinventory)
1358: AND sub2.organization_id = p_org_id

Line 1475: FROM MTL_SECONDARY_INVENTORIES S

1471: SUBINVENTORY = p_subinv) -- Included later for ORG Level
1472: and (SUBINVENTORY is null or
1473: p_level = 2 or
1474: EXISTS (SELECT 1
1475: FROM MTL_SECONDARY_INVENTORIES S
1476: WHERE S.ORGANIZATION_ID = p_org_id
1477: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1478: AND S.availability_type = DECODE(p_include_nonnet,
1479: 1,

Line 1521: FROM MTL_SECONDARY_INVENTORIES S

1517: SUBINVENTORY_CODE = p_subinv) -- Included later for ORG Level
1518: and (SUBINVENTORY_CODE is null or
1519: p_level = 2 or
1520: EXISTS (SELECT 1
1521: FROM MTL_SECONDARY_INVENTORIES S
1522: WHERE S.ORGANIZATION_ID = p_org_id
1523: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1524: AND S.availability_type = DECODE(p_include_nonnet,
1525: 1,

Line 1611: FROM MTL_SECONDARY_INVENTORIES S

1607: OR SUBINVENTORY = p_subinv) -- Included later for ORG Level
1608: and (SUBINVENTORY is null or
1609: p_level = 2 or
1610: EXISTS (SELECT 1
1611: FROM MTL_SECONDARY_INVENTORIES S
1612: WHERE S.ORGANIZATION_ID = p_org_id
1613: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1614: AND S.availability_type = DECODE(p_include_nonnet,
1615: 1,

Line 1658: FROM MTL_SECONDARY_INVENTORIES S

1654: SUBINVENTORY_CODE = p_subinv) -- Included later for ORG Level
1655: and (SUBINVENTORY_CODE is null or
1656: p_level = 2 or
1657: EXISTS (SELECT 1
1658: FROM MTL_SECONDARY_INVENTORIES S
1659: WHERE S.ORGANIZATION_ID = p_org_id
1660: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1661: AND S.availability_type = DECODE(p_include_nonnet,
1662: 1,

Line 1828: MTL_SECONDARY_INVENTORIES

1824: -- into consideration if Destination Type is Inventory and Destination Subinventory is Non Quantity Tracked
1825: ( pol.DESTINATION_TYPE_CODE = 'INVENTORY'
1826: AND pol.DESTINATION_SUBINVENTORY IS NOT NULL
1827: AND EXISTS (select 1 from
1828: MTL_SECONDARY_INVENTORIES
1829: where SECONDARY_INVENTORY_NAME = pol.DESTINATION_SUBINVENTORY
1830: and ORGANIZATION_ID = pol.DESTINATION_ORGANIZATION_ID
1831: and QUANTITY_TRACKED = 2)
1832: )

Line 1845: FROM MTL_SECONDARY_INVENTORIES S

1841: and schedule_ship_date <= p_d_cutoff + 0.99999 /* bug no 6009682 */
1842: and DECODE(so.SOURCE_DOCUMENT_TYPE_ID, 10, 8,DECODE(so.LINE_CATEGORY_CODE, 'ORDER',2,12)) = 8
1843: and (SUBINVENTORY is null or
1844: EXISTS (SELECT 1
1845: FROM MTL_SECONDARY_INVENTORIES S
1846: WHERE S.ORGANIZATION_ID = p_org_id
1847: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1848: AND S.availability_type = DECODE(p_include_nonnet,
1849: 1,

Line 1889: MTL_SECONDARY_INVENTORIES

1885: -- into consideration if Destination Type is Inventory and Destination Subinventory is Non Quantity Tracked
1886: ( pol.DESTINATION_TYPE_CODE = 'INVENTORY'
1887: AND pol.DESTINATION_SUBINVENTORY IS NOT NULL
1888: AND EXISTS (select 1 from
1889: MTL_SECONDARY_INVENTORIES
1890: where SECONDARY_INVENTORY_NAME = pol.DESTINATION_SUBINVENTORY
1891: and ORGANIZATION_ID = pol.DESTINATION_ORGANIZATION_ID
1892: and QUANTITY_TRACKED = 2)
1893: )

Line 1903: FROM MTL_SECONDARY_INVENTORIES S

1899: and REQUIREMENT_DATE <= p_d_cutoff + 0.99999 /* bug no 6009682 */
1900: and demand_source_type_id = 8
1901: and (SUBINVENTORY_CODE is null or
1902: EXISTS (SELECT 1
1903: FROM MTL_SECONDARY_INVENTORIES S
1904: WHERE S.ORGANIZATION_ID = p_org_id
1905: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1906: AND S.availability_type = DECODE(p_include_nonnet,
1907: 1,

Line 2033: FROM mtl_secondary_inventories s

2029: AND NVL(mtr.demand_source_type_id, 5) = 5
2030: AND d.material_requirement_date <= p_d_cutoff
2031: AND (mtr.subinventory_code IS NULL OR
2032: EXISTS (SELECT 1
2033: FROM mtl_secondary_inventories s
2034: WHERE s.organization_id = p_org_id
2035: AND s.secondary_inventory_name = mtr.subinventory_code
2036: AND s.availability_type = DECODE(p_include_nonnet,1,s.availability_type,1)))
2037: AND (mtr.locator_id IS NULL OR

Line 2147: FROM MTL_SECONDARY_INVENTORIES S

2143: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
2144: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
2145: p_level = 2 OR
2146: EXISTS (SELECT 1
2147: FROM MTL_SECONDARY_INVENTORIES S
2148: WHERE S.ORGANIZATION_ID = p_org_id
2149: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
2150: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2151: 1,S.AVAILABILITY_TYPE,1)))

Line 2173: FROM MTL_SECONDARY_INVENTORIES S

2169: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
2170: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
2171: p_level = 2 OR
2172: EXISTS (SELECT 1
2173: FROM MTL_SECONDARY_INVENTORIES S
2174: WHERE S.ORGANIZATION_ID = p_org_id
2175: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
2176: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2177: 1,S.AVAILABILITY_TYPE,1)))

Line 2266: FROM MTL_SECONDARY_INVENTORIES S

2262: SUBINVENTORY_CODE = p_subinv)
2263: and ( SUBINVENTORY_CODE is null or
2264: p_level = 2 or
2265: EXISTS (SELECT 1
2266: FROM MTL_SECONDARY_INVENTORIES S
2267: WHERE S.ORGANIZATION_ID = p_org_id
2268: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
2269: AND S.availability_type = DECODE(p_include_nonnet,
2270: 1,

Line 2900: FROM MTL_SECONDARY_INVENTORIES

2896: IF l_src_subinv IS NOT NULL THEN
2897: BEGIN
2898: SELECT LOCATION_ID
2899: INTO l_from_location_id
2900: FROM MTL_SECONDARY_INVENTORIES
2901: WHERE SECONDARY_INVENTORY_NAME = l_src_subinv
2902: AND ORGANIZATION_ID = l_src_org ;
2903: EXCEPTION
2904: WHEN no_data_found THEN

Line 3241: select nvl(location_id,0) into l_sub_loc_id from mtl_secondary_inventories

3237:
3238: l_location_id := p_location_id;
3239: If p_subinv is not null then
3240: begin
3241: select nvl(location_id,0) into l_sub_loc_id from mtl_secondary_inventories
3242: where secondary_inventory_name = p_subinv and organization_id = p_organization_id;
3243: exception
3244: when others then
3245: print_debug('Error getting Subinventory location_id', 'do_restock', 9);

Line 3261: SELECT asset_inventory,expense_account INTO l_asset_flag, l_exp_acct FROM mtl_secondary_inventories

3257: l_charge_acct := p_charge_acct ;
3258:
3259: If p_subinv is not null then
3260: begin
3261: SELECT asset_inventory,expense_account INTO l_asset_flag, l_exp_acct FROM mtl_secondary_inventories
3262: WHERE secondary_inventory_name = p_subinv and organization_id = p_organization_id;
3263: IF l_asset_flag = 2 AND l_exp_acct IS NOT NULL then
3264: l_charge_acct := l_exp_acct ;
3265: END IF;