DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 6783: FROM mtl_system_items mti

6779: -- AND ool.open_flag = 'Y' --bug3225795
6780: AND ool.line_category_code <> 'RETURN'
6781: AND NOT EXISTS
6782: (SELECT 'Non Invoiceable Item Line'
6783: FROM mtl_system_items mti
6784: WHERE mti.inventory_item_id = ool.inventory_item_id
6785: AND mti.organization_id = nvl(ool.ship_from_org_id,
6786: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
6787: AND (mti.invoiceable_item_flag = 'N'

Line 6811: FROM mtl_system_items mti, oe_order_lines_all ool

6807: WHERE op.line_id = p_line_id
6808: AND op.header_id = p_header_id
6809: AND NOT EXISTS
6810: (SELECT 'Non Invoiceable Item Line'
6811: FROM mtl_system_items mti, oe_order_lines_all ool
6812: WHERE ool.line_id = op.line_id
6813: AND mti.inventory_item_id = ool.inventory_item_id
6814: AND mti.organization_id = nvl(ool.ship_from_org_id,
6815: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 6829: FROM mtl_system_items mti

6825: --AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
6826: AND ool.line_category_code <> 'RETURN'
6827: AND NOT EXISTS
6828: (SELECT 'Non Invoiceable Item Line'
6829: FROM mtl_system_items mti
6830: WHERE mti.inventory_item_id = ool.inventory_item_id
6831: AND mti.organization_id = nvl(ool.ship_from_org_id,
6832: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
6833: AND (mti.invoiceable_item_flag = 'N'

Line 7051: FROM mtl_system_items mti

7047: -- AND ool.open_flag = 'Y'
7048: AND ool.line_category_code <> 'RETURN'
7049: AND NOT EXISTS
7050: (SELECT 'Non Invoiceable Item Line'
7051: FROM mtl_system_items mti
7052: WHERE mti.inventory_item_id = ool.inventory_item_id
7053: AND mti.organization_id = nvl(ool.ship_from_org_id,
7054: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7055: AND (mti.invoiceable_item_flag = 'N'

Line 7078: FROM mtl_system_items mti, oe_order_lines_all ool

7074: WHERE op.line_id = p_line_id
7075: AND op.header_id = p_header_id
7076: AND NOT EXISTS
7077: (SELECT 'Non Invoiceable Item Line'
7078: FROM mtl_system_items mti, oe_order_lines_all ool
7079: WHERE ool.line_id = op.line_id
7080: AND mti.inventory_item_id = ool.inventory_item_id
7081: AND mti.organization_id = nvl(ool.ship_from_org_id,
7082: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7094: FROM mtl_system_items mti

7090: AND ool.commitment_id is not null
7091: AND ool.line_category_code <> 'RETURN'
7092: AND NOT EXISTS
7093: (SELECT 'Non Invoiceable Item Line'
7094: FROM mtl_system_items mti
7095: WHERE mti.inventory_item_id = ool.inventory_item_id
7096: AND mti.organization_id = nvl(ool.ship_from_org_id,
7097: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7098: AND (mti.invoiceable_item_flag = 'N'

Line 7284: FROM mtl_system_items mti

7280: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7281: AND ool.line_category_code <> 'RETURN'
7282: AND NOT EXISTS
7283: (SELECT 'Non Invoiceable Item Line'
7284: FROM mtl_system_items mti
7285: WHERE mti.inventory_item_id = ool.inventory_item_id
7286: AND mti.organization_id = nvl(ool.ship_from_org_id,
7287: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7288: AND (mti.invoiceable_item_flag = 'N'

Line 7303: FROM mtl_system_items mti, oe_order_lines_all ool

7299: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7300: AND ool.line_id=op.line_id --bug3225795
7301: AND NOT EXISTS
7302: (SELECT 'Non Invoiceable Item Line'
7303: FROM mtl_system_items mti, oe_order_lines_all ool
7304: WHERE ool.line_id = op.line_id
7305: AND mti.inventory_item_id = ool.inventory_item_id
7306: AND mti.organization_id = nvl(ool.ship_from_org_id,
7307: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7322: FROM mtl_system_items mti

7318: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7319: AND ool.line_category_code <> 'RETURN'
7320: AND NOT EXISTS
7321: (SELECT 'Non Invoiceable Item Line'
7322: FROM mtl_system_items mti
7323: WHERE mti.inventory_item_id = ool.inventory_item_id
7324: AND mti.organization_id = nvl(ool.ship_from_org_id,
7325: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7326: AND (mti.invoiceable_item_flag = 'N'

Line 7366: FROM MTL_SYSTEM_ITEMS MTI

7362: AND nvl(L.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7363: AND L.line_category_code <> 'RETURN'
7364: AND NOT EXISTS
7365: (SELECT 'Non Invoiceable Item Line'
7366: FROM MTL_SYSTEM_ITEMS MTI
7367: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
7368: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
7369: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
7370: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'