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.INVPVALM dependencies on MTL_SYSTEM_ITEMS_B

Line 662: from mtl_system_items_B msi

658:
659: begin /* MASTER_CHILD_1A */
660:
661: select inventory_item_id into msicount
662: from mtl_system_items_B msi
663: where msi.inventory_item_id = cr.III
664: and msi.organization_id = cr.MORGID
665: and decode(A_BUYER_ID,X_TRUE,nvl(cr.BUYER_ID,-1),nvl(msi.BUYER_ID,-1))=nvl(msi.BUYER_ID,-1)
666: and decode(A_ACCOUNTING_RULE_ID,X_TRUE,nvl(cr.ACCOUNTING_RULE_ID,-1),nvl(msi.ACCOUNTING_RULE_ID,-1))=nvl(msi.ACCOUNTING_RULE_ID,-1)

Line 702: from mtl_system_items_B msi

698:
699: begin /* MASTER_CHILD_1C */
700:
701: select inventory_item_id into msicount
702: from mtl_system_items_B msi
703: where msi.inventory_item_id = cr.III
704: and msi.organization_id = cr.MORGID
705: and decode(A_PURCHASING_ENABLED_FLAG,X_TRUE,nvl(cr.PURCHASING_ENABLED_FLAG,-1),nvl(msi.PURCHASING_ENABLED_FLAG,-1))=nvl(msi.PURCHASING_ENABLED_FLAG,-1)
706: and decode(A_CUSTOMER_ORDER_ENABLED_FLAG,X_TRUE,nvl(cr.CUSTOMER_ORDER_ENABLED_FLAG,-1),nvl(msi.CUSTOMER_ORDER_ENABLED_FLAG,-1))=nvl(msi.CUSTOMER_ORDER_ENABLED_FLAG,-1)

Line 739: from mtl_system_items_B msi

735: begin /* MASTER_CHILD_1B */
736:
737: select inventory_item_id
738: into msicount
739: from mtl_system_items_B msi
740: where msi.inventory_item_id = cr.III
741: and msi.organization_id = cr.MORGID
742: and decode(A_STOCK_ENABLED_FLAG,X_TRUE,nvl(cr.STOCK_ENABLED_FLAG,-1),nvl(msi.STOCK_ENABLED_FLAG,-1))=nvl(msi.STOCK_ENABLED_FLAG,-1)
743: and decode(A_BOM_ENABLED_FLAG,X_TRUE,nvl(cr.BOM_ENABLED_FLAG,-1),nvl(msi.BOM_ENABLED_FLAG,-1))=nvl(msi.BOM_ENABLED_FLAG,-1)

Line 788: from mtl_system_items_B msi

784:
785: begin /* MASTER_CHILD_1D */
786:
787: select inventory_item_id into msicount
788: from mtl_system_items_B msi
789: where msi.inventory_item_id = cr.III
790: and msi.organization_id = cr.MORGID
791: and decode(A_CATALOG_STATUS_FLAG,X_TRUE,nvl(cr.CATALOG_STATUS_FLAG,-1),nvl(msi.CATALOG_STATUS_FLAG,-1))=nvl(msi.CATALOG_STATUS_FLAG,-1)
792: and decode(A_RETURNABLE_FLAG,X_TRUE,nvl(cr.RETURNABLE_FLAG,-1),nvl(msi.RETURNABLE_FLAG,-1))=nvl(msi.RETURNABLE_FLAG,-1)

Line 832: from mtl_system_items_B msi

828:
829: begin /* MASTER_CHILD_1E */
830:
831: select inventory_item_id into msicount
832: from mtl_system_items_B msi
833: where msi.inventory_item_id = cr.III
834: and msi.organization_id = cr.MORGID
835: and decode(A_HAZARD_CLASS_ID,X_TRUE,nvl(cr.HAZARD_CLASS_ID,-1),nvl(msi.HAZARD_CLASS_ID,-1))=nvl(msi.HAZARD_CLASS_ID,-1)
836: and decode(A_RFQ_REQUIRED_FLAG,X_TRUE,nvl(cr.RFQ_REQUIRED_FLAG,-1),nvl(msi.RFQ_REQUIRED_FLAG,-1))=nvl(msi.RFQ_REQUIRED_FLAG,-1)

Line 872: from mtl_system_items_B msi

868:
869: begin /* MASTER_CHILD_1F */
870:
871: select inventory_item_id into msicount
872: from mtl_system_items_B msi
873: where msi.inventory_item_id = cr.III
874: and msi.organization_id = cr.MORGID
875: and decode(A_ALLOW_SUBSTITUTE_RECEIPTS_F,X_TRUE,nvl(cr.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1),nvl(msi.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1))=nvl(msi.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,-1)
876: and decode(A_ALLOW_UNORDERED_RECEIPTS_F,X_TRUE,nvl(cr.ALLOW_UNORDERED_RECEIPTS_FLAG,-1),nvl(msi.ALLOW_UNORDERED_RECEIPTS_FLAG,-1))=nvl(msi.ALLOW_UNORDERED_RECEIPTS_FLAG,-1)

Line 954: FROM mtl_system_items_b msi

950: BEGIN /* MASTER_CHILD_1HA */
951:
952: SELECT inventory_item_id
953: INTO msicount
954: FROM mtl_system_items_b msi
955: WHERE msi.inventory_item_id = cr.III
956: AND msi.organization_id = cr.MORGID
957:
958: AND DECODE( A_OVERCOMPLETION_TOLERANCE_TYP,

Line 1009: FROM mtl_system_items_b msi

1005: BEGIN /* MASTER_CHILD_1HB */
1006:
1007: SELECT inventory_item_id
1008: INTO msicount
1009: FROM mtl_system_items_b msi
1010: WHERE msi.inventory_item_id = cr.III
1011: AND msi.organization_id = cr.MORGID
1012:
1013: AND DECODE( A_OVER_RETURN_TOLERANCE,

Line 1069: FROM mtl_system_items_b msi

1065: BEGIN /* MASTER_CHILD_1HC */
1066:
1067: SELECT inventory_item_id
1068: INTO msicount
1069: FROM mtl_system_items_b msi
1070: WHERE msi.inventory_item_id = cr.III
1071: AND msi.organization_id = cr.MORGID
1072:
1073: AND DECODE( A_EVENT_FLAG,

Line 1129: FROM mtl_system_items_b msi

1125: BEGIN /* MASTER_CHILD_1HD */
1126:
1127: SELECT inventory_item_id
1128: INTO msicount
1129: FROM mtl_system_items_b msi
1130: WHERE msi.inventory_item_id = cr.III
1131: AND msi.organization_id = cr.MORGID
1132:
1133: AND DECODE( A_COMMS_NL_TRACKABLE_FLAG,

Line 1190: FROM mtl_system_items_b msi

1186: BEGIN /* MASTER_CHILD_1IA */
1187:
1188: SELECT inventory_item_id
1189: INTO msicount
1190: FROM mtl_system_items_b msi
1191: WHERE msi.inventory_item_id = cr.III
1192: AND msi.organization_id = cr.MORGID
1193:
1194: AND DECODE( A_DIMENSION_UOM_CODE,

Line 1260: FROM mtl_system_items_b msi

1256: BEGIN /* MASTER_CHILD_1IB */
1257:
1258: SELECT inventory_item_id
1259: INTO msicount
1260: FROM mtl_system_items_b msi
1261: WHERE msi.inventory_item_id = cr.III
1262: AND msi.organization_id = cr.MORGID
1263:
1264: AND DECODE( A_SERIAL_STATUS_ENABLED,

Line 1316: FROM mtl_system_items_b msi

1312: BEGIN /* MASTER_CHILD_1IC */
1313:
1314: SELECT inventory_item_id
1315: INTO msicount
1316: FROM mtl_system_items_b msi
1317: WHERE msi.inventory_item_id = cr.III
1318: AND msi.organization_id = cr.MORGID
1319:
1320: AND DECODE( A_INVENTORY_CARRY_PENALTY,

Line 1367: FROM mtl_system_items_b msi

1363: BEGIN /* MASTER_CHILD_1J */
1364:
1365: SELECT inventory_item_id
1366: INTO msicount
1367: FROM mtl_system_items_b msi
1368: WHERE msi.inventory_item_id = cr.III
1369: AND msi.organization_id = cr.MORGID
1370:
1371: AND DECODE( A_EAM_ITEM_TYPE,

Line 1466: FROM mtl_system_items_b msi

1462: BEGIN /* MASTER_CHILD_1K */
1463:
1464: SELECT inventory_item_id
1465: INTO msicount
1466: FROM mtl_system_items_b msi
1467: WHERE msi.inventory_item_id = cr.III
1468: AND msi.organization_id = cr.MORGID
1469:
1470: AND DECODE( A_SERV_REQ_ENABLED_CODE,