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 1349: FROM mtl_secondary_inventories sub1

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

Line 1357: FROM mtl_secondary_inventories sub2

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

Line 1478: FROM MTL_SECONDARY_INVENTORIES S

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

Line 1524: FROM MTL_SECONDARY_INVENTORIES S

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

Line 1614: FROM MTL_SECONDARY_INVENTORIES S

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

Line 1661: FROM MTL_SECONDARY_INVENTORIES S

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

Line 1831: MTL_SECONDARY_INVENTORIES

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

Line 1848: FROM MTL_SECONDARY_INVENTORIES S

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

Line 1892: MTL_SECONDARY_INVENTORIES

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

Line 1906: FROM MTL_SECONDARY_INVENTORIES S

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

Line 2043: FROM mtl_secondary_inventories s

2039: AND NVL(mtr.demand_source_type_id, 5) = 5
2040: AND d.material_requirement_date <= p_d_cutoff
2041: AND (mtr.subinventory_code IS NULL OR
2042: EXISTS (SELECT 1
2043: FROM mtl_secondary_inventories s
2044: WHERE s.organization_id = p_org_id
2045: AND s.secondary_inventory_name = mtr.subinventory_code
2046: AND s.availability_type = DECODE(p_include_nonnet,1,s.availability_type,1)))
2047: AND (mtr.locator_id IS NULL OR

Line 2157: FROM MTL_SECONDARY_INVENTORIES S

2153: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
2154: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
2155: p_level = 2 OR
2156: EXISTS (SELECT 1
2157: FROM MTL_SECONDARY_INVENTORIES S
2158: WHERE S.ORGANIZATION_ID = p_org_id
2159: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
2160: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2161: 1,S.AVAILABILITY_TYPE,1)))

Line 2183: FROM MTL_SECONDARY_INVENTORIES S

2179: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
2180: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
2181: p_level = 2 OR
2182: EXISTS (SELECT 1
2183: FROM MTL_SECONDARY_INVENTORIES S
2184: WHERE S.ORGANIZATION_ID = p_org_id
2185: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
2186: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2187: 1,S.AVAILABILITY_TYPE,1)))

Line 2276: FROM MTL_SECONDARY_INVENTORIES S

2272: SUBINVENTORY_CODE = p_subinv)
2273: and ( SUBINVENTORY_CODE is null or
2274: p_level = 2 or
2275: EXISTS (SELECT 1
2276: FROM MTL_SECONDARY_INVENTORIES S
2277: WHERE S.ORGANIZATION_ID = p_org_id
2278: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
2279: AND S.availability_type = DECODE(p_include_nonnet,
2280: 1,

Line 2910: FROM MTL_SECONDARY_INVENTORIES

2906: IF l_src_subinv IS NOT NULL THEN
2907: BEGIN
2908: SELECT LOCATION_ID
2909: INTO l_from_location_id
2910: FROM MTL_SECONDARY_INVENTORIES
2911: WHERE SECONDARY_INVENTORY_NAME = l_src_subinv
2912: AND ORGANIZATION_ID = l_src_org ;
2913: EXCEPTION
2914: WHEN no_data_found THEN

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

3247:
3248: l_location_id := p_location_id;
3249: If p_subinv is not null then
3250: begin
3251: select nvl(location_id,0) into l_sub_loc_id from mtl_secondary_inventories
3252: where secondary_inventory_name = p_subinv and organization_id = p_organization_id;
3253: exception
3254: when others then
3255: print_debug('Error getting Subinventory location_id', 'do_restock', 9);

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

3267: l_charge_acct := p_charge_acct ;
3268:
3269: If p_subinv is not null then
3270: begin
3271: SELECT asset_inventory,expense_account INTO l_asset_flag, l_exp_acct FROM mtl_secondary_inventories
3272: WHERE secondary_inventory_name = p_subinv and organization_id = p_organization_id;
3273: IF l_asset_flag = 2 AND l_exp_acct IS NOT NULL then
3274: l_charge_acct := l_exp_acct ;
3275: END IF;