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.OE_VERIFY_PAYMENT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 7408: FROM mtl_system_items mti

7404: AND ool.line_category_code <> 'RETURN'
7405: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7406: AND NOT EXISTS
7407: (SELECT 'Non Invoiceable Item Line'
7408: FROM mtl_system_items mti
7409: WHERE mti.inventory_item_id = ool.inventory_item_id
7410: AND mti.organization_id = nvl(ool.ship_from_org_id,
7411: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7412: AND (mti.invoiceable_item_flag = 'N'

Line 7436: FROM mtl_system_items mti, oe_order_lines_all ool

7432: WHERE op.line_id = p_line_id
7433: AND op.header_id = p_header_id
7434: AND NOT EXISTS
7435: (SELECT 'Non Invoiceable Item Line'
7436: FROM mtl_system_items mti, oe_order_lines_all ool
7437: WHERE ool.line_id = op.line_id
7438: AND mti.inventory_item_id = ool.inventory_item_id
7439: AND mti.organization_id = nvl(ool.ship_from_org_id,
7440: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7456: FROM mtl_system_items mti

7452: AND ool.line_category_code <> 'RETURN'
7453: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7454: AND NOT EXISTS
7455: (SELECT 'Non Invoiceable Item Line'
7456: FROM mtl_system_items mti
7457: WHERE mti.inventory_item_id = ool.inventory_item_id
7458: AND mti.organization_id = nvl(ool.ship_from_org_id,
7459: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7460: AND (mti.invoiceable_item_flag = 'N'

Line 7684: FROM mtl_system_items mti

7680: AND ool.line_category_code <> 'RETURN'
7681: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7682: AND NOT EXISTS
7683: (SELECT 'Non Invoiceable Item Line'
7684: FROM mtl_system_items mti
7685: WHERE mti.inventory_item_id = ool.inventory_item_id
7686: AND mti.organization_id = nvl(ool.ship_from_org_id,
7687: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7688: AND (mti.invoiceable_item_flag = 'N'

Line 7711: FROM mtl_system_items mti, oe_order_lines_all ool

7707: WHERE op.line_id = p_line_id
7708: AND op.header_id = p_header_id
7709: AND NOT EXISTS
7710: (SELECT 'Non Invoiceable Item Line'
7711: FROM mtl_system_items mti, oe_order_lines_all ool
7712: WHERE ool.line_id = op.line_id
7713: AND mti.inventory_item_id = ool.inventory_item_id
7714: AND mti.organization_id = nvl(ool.ship_from_org_id,
7715: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7729: FROM mtl_system_items mti

7725: AND ool.line_category_code <> 'RETURN'
7726: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7727: AND NOT EXISTS
7728: (SELECT 'Non Invoiceable Item Line'
7729: FROM mtl_system_items mti
7730: WHERE mti.inventory_item_id = ool.inventory_item_id
7731: AND mti.organization_id = nvl(ool.ship_from_org_id,
7732: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7733: AND (mti.invoiceable_item_flag = 'N'

Line 7923: FROM mtl_system_items mti

7919: AND ool.line_category_code <> 'RETURN'
7920: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7921: AND NOT EXISTS
7922: (SELECT 'Non Invoiceable Item Line'
7923: FROM mtl_system_items mti
7924: WHERE mti.inventory_item_id = ool.inventory_item_id
7925: AND mti.organization_id = nvl(ool.ship_from_org_id,
7926: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7927: AND (mti.invoiceable_item_flag = 'N'

Line 7942: FROM mtl_system_items mti, oe_order_lines_all ool

7938: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7939: AND ool.line_id=op.line_id --bug3225795
7940: AND NOT EXISTS
7941: (SELECT 'Non Invoiceable Item Line'
7942: FROM mtl_system_items mti, oe_order_lines_all ool
7943: WHERE ool.line_id = op.line_id
7944: AND mti.inventory_item_id = ool.inventory_item_id
7945: AND mti.organization_id = nvl(ool.ship_from_org_id,
7946: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7965: FROM mtl_system_items mti

7961: AND ool.line_category_code <> 'RETURN'
7962: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165
7963: AND NOT EXISTS
7964: (SELECT 'Non Invoiceable Item Line'
7965: FROM mtl_system_items mti
7966: WHERE mti.inventory_item_id = ool.inventory_item_id
7967: AND mti.organization_id = nvl(ool.ship_from_org_id,
7968: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7969: AND (mti.invoiceable_item_flag = 'N'

Line 8010: FROM MTL_SYSTEM_ITEMS MTI

8006: AND nvl(L.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
8007: AND L.line_category_code <> 'RETURN'
8008: AND NOT EXISTS
8009: (SELECT 'Non Invoiceable Item Line'
8010: FROM MTL_SYSTEM_ITEMS MTI
8011: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
8012: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
8013: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
8014: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'