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.INVPPRCI dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 24: mtl_system_items_interface SI,

20:
21: cursor allconfig is
22: select sla.line_id, si.organization_id,sla.project_id
23: from so_headers_all SOH,
24: mtl_system_items_interface SI,
25: mtl_sales_orders mso,
26: so_order_types_all sot,
27: so_lines_all sla
28: where si.demand_source_header_id = mso.sales_order_id

Line 499: MTL_SYSTEM_ITEMS_INTERFACE I

495: from
496: MTL_PARAMETERS MP1,
497: MTL_PARAMETERS MP2,
498: MTL_SYSTEM_ITEMS_B M, /* Model */
499: MTL_SYSTEM_ITEMS_INTERFACE I
500: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID
501: and I.COPY_ITEM_ID = M.INVENTORY_ITEM_ID
502: and I.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))
503: and MP2.organization_id = I.organization_id

Line 537: MTL_SYSTEM_ITEMS_INTERFACE I

533: from
534: MTL_PARAMETERS MP1,
535: MTL_PARAMETERS MP2,
536: MTL_SYSTEM_ITEMS_B M, /* Model */
537: MTL_SYSTEM_ITEMS_INTERFACE I
538: , FND_LANGUAGES L
539: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID
540: and I.COPY_ITEM_ID = M.INVENTORY_ITEM_ID
541: and I.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 583: MTL_SYSTEM_ITEMS_INTERFACE R

579: SYSDATE
580: from
581: MTL_PARAMETERS MP1,
582: MTL_PARAMETERS MP2,
583: MTL_SYSTEM_ITEMS_INTERFACE R
584: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
585: and MP2.organization_id = R.organization_id
586: and ((R.ORGANIZATION_ID = MP1.ORGANIZATION_ID) OR
587: (MP1.ORGANIZATION_ID = MP2.master_organization_id) OR

Line 626: MTL_SYSTEM_ITEMS_INTERFACE R

622: req_id
623: from MTL_SYSTEM_ITEMS_B SI,
624: MTL_PARAMETERS MP1,
625: MTL_PARAMETERS MP2,
626: MTL_SYSTEM_ITEMS_INTERFACE R
627: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
628: and R.inventory_item_id = SI.inventory_item_id
629: and R.organization_id = SI.organization_id
630: and MP2.organization_id = R.organization_id

Line 769: MTL_SYSTEM_ITEMS_INTERFACE SI

765: from
766: CST_ITEM_COSTS C,
767: MTL_PARAMETERS MP1,
768: MTL_PARAMETERS MP2,
769: MTL_SYSTEM_ITEMS_INTERFACE SI
770: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
771: and C.INVENTORY_ITEM_ID = SI.Copy_item_id
772: and C.COST_TYPE_ID IN ( MP1.PRIMARY_COST_METHOD, MP1.AVG_RATES_COST_TYPE_ID)
773: and SI.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 883: MTL_SYSTEM_ITEMS_INTERFACE SI

879: from
880: CST_ITEM_COST_DETAILS C,
881: MTL_PARAMETERS MP1,
882: MTL_PARAMETERS MP2,
883: MTL_SYSTEM_ITEMS_INTERFACE SI
884: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
885: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
886: and C.COST_TYPE_ID IN ( MP1.PRIMARY_COST_METHOD, MP1.AVG_RATES_COST_TYPE_ID)
887: and SI.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))

Line 985: MTL_SYSTEM_ITEMS_INTERFACE SI,

981: 0,
982: 0,
983: -1 /* txn_id */
984: from
985: MTL_SYSTEM_ITEMS_INTERFACE SI,
986: MTL_PARAMETERS MP1,
987: MTL_PARAMETERS MP2,
988: CST_ITEM_COSTS C
989: where

Line 1037: MTL_SYSTEM_ITEMS_INTERFACE SI

1033: req_id, /* REQUEST_ID */
1034: NVL(V.ELEMENT_SEQUENCE,M.ELEMENT_SEQUENCE)
1035: from MTL_DESCR_ELEMENT_VALUES M, /* Model's desc elem values */
1036: MTL_DESC_ELEM_VAL_INTERFACE V,
1037: MTL_SYSTEM_ITEMS_INTERFACE SI
1038: where V.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
1039: and SI.SET_ID = TO_CHAR(to_number(USERENV('SESSIONID')))
1040: and M.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
1041: and M.ELEMENT_NAME = V.ELEMENT_NAME; /* This where clause was */

Line 1079: mtl_system_items_interface si

1075: MP1.organization_id
1076: from MTL_PARAMETERS MP1,
1077: MTL_PARAMETERS MP2,
1078: mtl_item_categories_interface ici,
1079: mtl_system_items_interface si
1080: where si.inventory_item_id = ici.inventory_item_id
1081: and si.organization_id = ici.organization_id
1082: and ici.category_set_id is not NULL
1083: and ici.category_id is not NULL

Line 1123: mtl_system_items_interface si

1119: from
1120: mtl_item_categories ic,
1121: MTL_PARAMETERS MP1,
1122: MTL_PARAMETERS MP2,
1123: mtl_system_items_interface si
1124: where si.copy_item_id = ic.inventory_item_id
1125: and si.organization_id = ic.organization_id
1126: and MP2.organization_id = si.organization_id
1127: and not exists ( select NULL

Line 1174: mtl_system_items_interface si

1170: prg_id, /* program_id */
1171: SYSDATE, /* program_update_date */
1172: rii.organization_id
1173: from mtl_related_items_interface rii,
1174: mtl_system_items_interface si
1175: where rii.inventory_item_id = si.inventory_item_id
1176: and rii.organization_id = si.organization_id
1177: and rii.related_item_id is not NULL
1178: and rii.relationship_type_id is not NULL

Line 1216: mtl_system_items_interface si

1212: prg_id, /* program_id */
1213: SYSDATE, /* program_update_date */
1214: ri.organization_id
1215: from mtl_related_items ri,
1216: mtl_system_items_interface si
1217: where ri.inventory_item_id = si.copy_item_id
1218: and ri.organization_id = si.organization_id
1219: and not exists ( select NULL
1220: from mtl_related_items_interface rii

Line 1316: mtl_system_items_interface si

1312: SYSDATE, /* program_update_date */
1313: isii.ENCUMBRANCE_ACCOUNT
1314: from
1315: mtl_item_sub_invs_interface isii,
1316: mtl_system_items_interface si
1317: where si.organization_id = isii.organization_id
1318: and si.inventory_item_id = isii.inventory_item_id
1319: and isii.secondary_inventory is not NULL
1320: and isii.inventory_planning_code is not NULL

Line 1409: mtl_system_items_interface si

1405: SYSDATE, /* program_update_date */
1406: isi.ENCUMBRANCE_ACCOUNT
1407: from
1408: mtl_item_sub_inventories isi,
1409: mtl_system_items_interface si
1410: where si.organization_id = isi.organization_id
1411: and si.copy_item_id = isi.inventory_item_id
1412: and not exists ( select NULL
1413: from mtl_item_sub_invs_interface isii

Line 1458: mtl_system_items_interface si

1454: prg_id, /* program_id */
1455: SYSDATE /* program_update_date */
1456: from
1457: mtl_secondary_locs_interface sli,
1458: mtl_system_items_interface si
1459: where si.organization_id = sli.organization_id
1460: and si.inventory_item_id = sli.inventory_item_id
1461: and sli.secondary_locator is not NULL
1462: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 1501: mtl_system_items_interface si

1497: prg_id, /* program_id */
1498: SYSDATE /* program_update_date */
1499: from
1500: mtl_secondary_locators sl,
1501: mtl_system_items_interface si
1502: where si.organization_id = sl.organization_id
1503: and si.copy_item_id = sl.inventory_item_id
1504: and not exists ( select NULL
1505: from mtl_secondary_locs_interface sli

Line 1549: mtl_system_items_interface si

1545: prg_id, /* program_id */
1546: SYSDATE /* program_update_date */
1547: from
1548: mtl_cross_references_interface cri,
1549: mtl_system_items_interface si
1550: where (si.organization_id = cri.organization_id or
1551: cri.organization_id is NULL)
1552: and si.inventory_item_id = cri.inventory_item_id
1553: and cri.cross_reference_type is not NULL

Line 1595: mtl_system_items_interface si

1591: prg_id, /* program_id */
1592: SYSDATE /* program_update_date */
1593: from
1594: mtl_cross_references cr,
1595: mtl_system_items_interface si
1596: where (si.organization_id = cr.organization_id or
1597: cr.organization_id is NULL)
1598: and si.copy_item_id = cr.inventory_item_id
1599: and not exists (select NULL

Line 1612: MTL_SYSTEM_ITEMS_INTERFACE si

1608: table_name := 'MTL_DESC_ELEM_VAL_INTERFACE';
1609: delete from MTL_DESC_ELEM_VAL_INTERFACE di
1610: where di.rowid in ( select di2.rowid
1611: from MTL_DESC_ELEM_VAL_INTERFACE di2,
1612: MTL_SYSTEM_ITEMS_INTERFACE si
1613: where si.inventory_item_id = di2.inventory_item_id
1614: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1615:
1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';

Line 1620: MTL_SYSTEM_ITEMS_INTERFACE si

1616: table_name := 'MTL_ITEM_CATEGORIES_INTERFACE';
1617: delete from MTL_ITEM_CATEGORIES_INTERFACE ci
1618: where ci.rowid in ( select ci2.rowid
1619: from MTL_ITEM_CATEGORIES_INTERFACE ci2,
1620: MTL_SYSTEM_ITEMS_INTERFACE si
1621: where si.inventory_item_id = ci2.inventory_item_id
1622: and si.organization_id = ci2.organization_id
1623: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1624:

Line 1629: MTL_SYSTEM_ITEMS_INTERFACE si

1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si
1630: where si.inventory_item_id = ri2.inventory_item_id
1631: and si.organization_id = ri2.organization_id
1632: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1633:

Line 1638: MTL_SYSTEM_ITEMS_INTERFACE si

1634: table_name := 'MTL_ITEM_SUB_INVS_INTERFACE';
1635: delete from MTL_ITEM_SUB_INVS_INTERFACE ii
1636: where ii.rowid in ( select ii2.rowid
1637: from MTL_ITEM_SUB_INVS_INTERFACE ii2,
1638: MTL_SYSTEM_ITEMS_INTERFACE si
1639: where si.inventory_item_id = ii2.inventory_item_id
1640: and si.organization_id = ii2.organization_id
1641: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1642:

Line 1647: MTL_SYSTEM_ITEMS_INTERFACE si

1643: table_name := 'MTL_SECONDARY_LOCS_INTERFACE';
1644: delete from MTL_SECONDARY_LOCS_INTERFACE li
1645: where li.rowid in ( select li2.rowid
1646: from MTL_SECONDARY_LOCS_INTERFACE li2,
1647: MTL_SYSTEM_ITEMS_INTERFACE si
1648: where si.inventory_item_id = li2.inventory_item_id
1649: and si.organization_id = li2.organization_id
1650: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1651:

Line 1656: MTL_SYSTEM_ITEMS_INTERFACE si

1652: table_name := 'MTL_CROSS_REFERENCES_INTERFACE';
1653: delete from MTL_CROSS_REFERENCES_INTERFACE ri
1654: where rowid in ( select ri2.rowid
1655: from MTL_CROSS_REFERENCES_INTERFACE ri2,
1656: MTL_SYSTEM_ITEMS_INTERFACE si
1657: where si.inventory_item_id = ri2.inventory_item_id
1658: and (si.organization_id = ri2.organization_id or
1659: ri2.organization_id is NULL)
1660: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));

Line 1666: MTL_SYSTEM_ITEMS_INTERFACE si

1662: table_name := 'CST_ITEM_COSTS_INTERFACE';
1663: delete from CST_ITEM_COSTS_INTERFACE ci
1664: where ci.rowid in ( select ci2.rowid
1665: from CST_ITEM_COSTS_INTERFACE ci2,
1666: MTL_SYSTEM_ITEMS_INTERFACE si
1667: where si.inventory_item_id = ci2.inventory_item_id
1668: and si.organization_id = ci2.organization_id
1669: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1670:

Line 1675: MTL_SYSTEM_ITEMS_INTERFACE si

1671: table_name := 'CST_ITEM_CST_DTLS_INTERFACE';
1672: delete from CST_ITEM_CST_DTLS_INTERFACE ci
1673: where ci.rowid in ( select ci2.rowid
1674: from CST_ITEM_CST_DTLS_INTERFACE ci2,
1675: MTL_SYSTEM_ITEMS_INTERFACE si
1676: where si.inventory_item_id = ci2.inventory_item_id
1677: and si.organization_id = ci2.organization_id
1678: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1679: return(1);