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.CSP_MINMAX_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 388: mtl_secondary_inventories m,

384: FROM mtl_categories b,
385: mtl_item_categories a,
386: mtl_system_items c,
387: mtl_parameters p,
388: mtl_secondary_inventories m,
389: mtl_item_sub_inventories s
390: WHERE b.category_id = a.category_id
391: AND b.structure_id = :mcat_struct_id
392: AND c.inventory_item_flag = ''Y''

Line 534: mtl_secondary_inventories m,

530: FROM mtl_categories b,
531: mtl_item_categories a,
532: mtl_system_items c,
533: mtl_parameters p,
534: mtl_secondary_inventories m,
535: mtl_item_sub_inventories s,
536: per_all_people_f v
537: WHERE b.category_id = a.category_id
538: AND b.structure_id = :mcat_struct_id

Line 966: AND EXISTS (select 'x' from mtl_secondary_inventories msi

962: INTO l_moq_qty1
963: FROM mtl_onhand_quantities_detail moqd
964: WHERE moqd.organization_id = p_org_id
965: AND moqd.inventory_item_id = p_item_id
966: AND EXISTS (select 'x' from mtl_secondary_inventories msi
967: WHERE msi.organization_id = moqd.organization_id and
968: msi.secondary_inventory_name = moqd.subinventory_code
969: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))
970: AND nvl(moqd.planning_tp_type,2) = 2;

Line 984: AND EXISTS (select 'x' from mtl_secondary_inventories msi

980: AND mmtt.posting_flag = 'Y'
981: AND mmtt.subinventory_code IS NOT NULL
982: AND Nvl(mmtt.transaction_status,0) <> 2
983: AND mmtt.transaction_action_id NOT IN (24,30)
984: AND EXISTS (select 'x' from mtl_secondary_inventories msi
985: WHERE msi.organization_id = mmtt.organization_id
986: AND msi.secondary_inventory_name = mmtt.subinventory_code
987: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))
988: AND nvl(mmtt.planning_tp_type,2) = 2;

Line 1003: AND EXISTS (select 'x' from mtl_secondary_inventories msi

999: AND Nvl(mmtt.transaction_status,0) <> 2
1000: AND mmtt.transaction_action_id in (2,28,3)
1001: AND ((mmtt.transfer_subinventory IS NULL) OR
1002: (mmtt.transfer_subinventory IS NOT NULL
1003: AND EXISTS (select 'x' from mtl_secondary_inventories msi
1004: WHERE msi.organization_id = decode(mmtt.transaction_action_id,
1005: 3, mmtt.transfer_organization,mmtt.organization_id)
1006: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
1007: AND msi.availability_type = decode(p_include_nonnet,1,msi.availability_type,1))))

Line 1157: FROM mtl_secondary_inventories sub1

1153: OR (sup.from_organization_id = :l_org_id
1154: AND ((:l_include_nonnet = 2
1155: AND
1156: EXISTS (SELECT ''x''
1157: FROM mtl_secondary_inventories sub1
1158: WHERE sub1.organization_id = sup.from_organization_id
1159: AND sub1.secondary_inventory_name = sup.from_subinventory
1160: AND sub1.availability_type <> 1
1161: )

Line 1170: FROM mtl_secondary_inventories sub2

1166: )
1167: AND (sup.to_subinventory IS NULL
1168: OR
1169: (EXISTS (SELECT ''x''
1170: FROM mtl_secondary_inventories sub2
1171: WHERE sub2.secondary_inventory_name = sup.to_subinventory
1172: AND sub2.organization_id = sup.to_organization_id
1173: AND sub2.availability_type = decode(:l_include_nonnet,
1174: 1,sub2.availability_type,

Line 1373: FROM mtl_secondary_inventories sub1

1369: AND (NVL(source_organization_id,-1) <> p_org_id OR
1370: (source_organization_id = p_org_id AND
1371: (( p_include_nonnet = 2 AND
1372: EXISTS (SELECT 'x'
1373: FROM mtl_secondary_inventories sub1
1374: WHERE sub1.organization_id = source_organization_id
1375: AND sub1.secondary_inventory_name = source_subinventory
1376: AND sub1.availability_type <> 1)) OR
1377: p_level = 2)

Line 1381: FROM mtl_secondary_inventories sub2

1377: p_level = 2)
1378: ))
1379: AND (destination_subinventory IS NULL OR
1380: EXISTS (SELECT 1
1381: FROM mtl_secondary_inventories sub2
1382: WHERE secondary_inventory_name = destination_subinventory
1383: AND destination_subinventory = NVL(p_subinv,
1384: destination_subinventory)
1385: AND sub2.organization_id = p_org_id

Line 1488: FROM MTL_SECONDARY_INVENTORIES S

1484: SUBINVENTORY = p_subinv) -- Included later for ORG Level
1485: and (SUBINVENTORY is null or
1486: p_level = 2 or
1487: EXISTS (SELECT 1
1488: FROM MTL_SECONDARY_INVENTORIES S
1489: WHERE S.ORGANIZATION_ID = p_org_id
1490: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1491: AND S.availability_type = DECODE(p_include_nonnet,
1492: 1,

Line 1516: FROM MTL_SECONDARY_INVENTORIES S

1512: SUBINVENTORY_CODE = p_subinv) -- Included later for ORG Level
1513: and (SUBINVENTORY_CODE is null or
1514: p_level = 2 or
1515: EXISTS (SELECT 1
1516: FROM MTL_SECONDARY_INVENTORIES S
1517: WHERE S.ORGANIZATION_ID = p_org_id
1518: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1519: AND S.availability_type = DECODE(p_include_nonnet,
1520: 1,

Line 1584: FROM MTL_SECONDARY_INVENTORIES S

1580: OR SUBINVENTORY = p_subinv) -- Included later for ORG Level
1581: and (SUBINVENTORY is null or
1582: p_level = 2 or
1583: EXISTS (SELECT 1
1584: FROM MTL_SECONDARY_INVENTORIES S
1585: WHERE S.ORGANIZATION_ID = p_org_id
1586: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1587: AND S.availability_type = DECODE(p_include_nonnet,
1588: 1,

Line 1630: FROM MTL_SECONDARY_INVENTORIES S

1626: SUBINVENTORY_CODE = p_subinv) -- Included later for ORG Level
1627: and (SUBINVENTORY_CODE is null or
1628: p_level = 2 or
1629: EXISTS (SELECT 1
1630: FROM MTL_SECONDARY_INVENTORIES S
1631: WHERE S.ORGANIZATION_ID = p_org_id
1632: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1633: AND S.availability_type = DECODE(p_include_nonnet,
1634: 1,

Line 1717: FROM MTL_SECONDARY_INVENTORIES S

1713: and schedule_ship_date <= p_d_cutoff
1714: and DECODE(so.SOURCE_DOCUMENT_TYPE_ID, 10, 8,DECODE(so.LINE_CATEGORY_CODE, 'ORDER',2,12)) = 8
1715: and (SUBINVENTORY is null or
1716: EXISTS (SELECT 1
1717: FROM MTL_SECONDARY_INVENTORIES S
1718: WHERE S.ORGANIZATION_ID = p_org_id
1719: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1720: AND S.availability_type = DECODE(p_include_nonnet,
1721: 1,

Line 1759: FROM MTL_SECONDARY_INVENTORIES S

1755: and REQUIREMENT_DATE <= p_d_cutoff
1756: and demand_source_type_id = 8
1757: and (SUBINVENTORY_CODE is null or
1758: EXISTS (SELECT 1
1759: FROM MTL_SECONDARY_INVENTORIES S
1760: WHERE S.ORGANIZATION_ID = p_org_id
1761: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1762: AND S.availability_type = DECODE(p_include_nonnet,
1763: 1,

Line 1905: FROM MTL_SECONDARY_INVENTORIES S

1901: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
1902: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
1903: p_level = 2 OR
1904: EXISTS (SELECT 1
1905: FROM MTL_SECONDARY_INVENTORIES S
1906: WHERE S.ORGANIZATION_ID = p_org_id
1907: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
1908: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
1909: 1,S.AVAILABILITY_TYPE,1)))

Line 1931: FROM MTL_SECONDARY_INVENTORIES S

1927: MTRL.FROM_SUBINVENTORY_CODE = p_subinv)
1928: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
1929: p_level = 2 OR
1930: EXISTS (SELECT 1
1931: FROM MTL_SECONDARY_INVENTORIES S
1932: WHERE S.ORGANIZATION_ID = p_org_id
1933: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
1934: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
1935: 1,S.AVAILABILITY_TYPE,1)))

Line 2058: FROM mtl_secondary_inventories s

2054: AND subinventory_code IS NOT NULL
2055: AND (subinventory_code = p_subinv
2056: OR
2057: EXISTS (SELECT 1
2058: FROM mtl_secondary_inventories s
2059: WHERE s.organization_id = p_org_id
2060: AND s.secondary_inventory_name = subinventory_code
2061: AND s.availability_type = DECODE(p_include_nonnet,
2062: 1,