VIEW: APPS.IGW_NON_LABOR_FORMAT_V

Source

View Text - Preformatted

SELECT inv_fmt.name , inv_fmt.invoice_format_id from pa_invoice_formats inv_fmt , pa_invoice_groups inv_grp WHERE inv_fmt.invoice_group_id = inv_grp.invoice_group_id and inv_grp.invoice_format_type = 'NON-LABOR'

View Text - HTML Formatted

SELECT INV_FMT.NAME
, INV_FMT.INVOICE_FORMAT_ID
FROM PA_INVOICE_FORMATS INV_FMT
, PA_INVOICE_GROUPS INV_GRP
WHERE INV_FMT.INVOICE_GROUP_ID = INV_GRP.INVOICE_GROUP_ID
AND INV_GRP.INVOICE_FORMAT_TYPE = 'NON-LABOR'