SELECT nvl( "GL_SETS_OF_BOOKS"."PERIOD_SET_NAME" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."PERIOD_NAME" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."SET_OF_BOOKS_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."LINE_TYPE_LOOKUP_CODE" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."CREATION_DATE" ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."LAST_UPDATE_DATE" ) , nvl( "AP_INVOICES_ALL"."VENDOR_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."VENDOR_SITE_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."TERMS_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."SOURCE" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."INVOICE_TYPE_LOOKUP_CODE" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."PAYMENT_STATUS_FLAG" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."BATCH_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."PROJECT_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."CREATED_BY" ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."LAST_UPDATED_BY" ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."DESCRIPTION" ,  $G_DEFAULT_TEXT ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."FINAL_MATCH_FLAG" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."MATCH_STATUS_FLAG" ,  $G_DEFAULT_NUMBER ) , DECODE( "AP_INVOICE_DISTRIBUTIONS_ALL"."MATCH_STATUS_FLAG" , 'T', 'Tested', DECODE( "AP_INVOICE_DISTRIBUTIONS_ALL"."MATCH_STATUS_FLAG" , 'A', 'Tested and Approved', 'Not Tested')) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_MATCH_TYPE" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."POSTED_FLAG" , 'N') , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."REVERSAL_FLAG" , 'N') , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."ORG_ID" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICES_ALL"."INVOICE_CURRENCY_CODE" ,  $G_DEFAULT_NUMBER ) , nvl( "GL_SETS_OF_BOOKS"."CURRENCY_CODE" ,  $G_DEFAULT_NUMBER ) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."BASE_AMOUNT" , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."AMOUNT" , 0)) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."QUANTITY_VARIANCE" , 0) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."BASE_QUANTITY_VARIANCE" , 0) , nvl( "AP_INVOICE_DISTRIBUTIONS_ALL"."BASE_INVOICE_PRICE_VARIANCE" , 0) ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."DISTRIBUTION_LINE_NUMBER"  ,  "AP_INVOICES_ALL"."INVOICE_NUM"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ACCOUNTING_DATE"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."MATCHED_UOM_LOOKUP_CODE"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."QUANTITY_INVOICED"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."QUANTITY_VARIANCE"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."UNIT_PRICE"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."AMOUNT"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE1"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE10"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE2"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE3"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE4"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE5"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE6"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE7"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE8"  ,  "PO_HEADERS_ALL"."SEGMENT1"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE11"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE12"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE13"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE14"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE15"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE9"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."ATTRIBUTE_CATEGORY"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."TASK_ID"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE1"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE2"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE3"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE4"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE5"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE6"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE7"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE8"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE9"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE10"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE11"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE12"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE13"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE14"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE15"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE16"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE17"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE18"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE19"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."GLOBAL_ATTRIBUTE20"  ,  "AP_INVOICES_ALL"."INVOICE_DATE"  ,  "AP_INVOICES_ALL"."EXPENDITURE_ORGANIZATION_ID"  ,  "AP_INVOICE_DISTRIBUTIONS_ALL"."EXPENDITURE_TYPE"  ,  "AP_INVOICES_ALL"."INVOICE_RECEIVED_DATE" 
FROM "PO"."PO_HEADERS_ALL" "PO_HEADERS_ALL", "GL"."GL_SETS_OF_BOOKS" "GL_SETS_OF_BOOKS", "AP"."AP_INVOICES_ALL" "AP_INVOICES_ALL", "AP"."AP_INVOICE_DISTRIBUTIONS_ALL" "AP_INVOICE_DISTRIBUTIONS_ALL", "PO"."PO_DISTRIBUTIONS_ALL" "PO_DISTRIBUTIONS_ALL"
WHERE ( "AP_INVOICE_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID"  =  "PO_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID" ) AND ( "AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"  =  "AP_INVOICES_ALL"."INVOICE_ID" ) AND ( "AP_INVOICE_DISTRIBUTIONS_ALL"."SET_OF_BOOKS_ID"  =  "GL_SETS_OF_BOOKS"."SET_OF_BOOKS_ID" ) AND ( "AP_INVOICE_DISTRIBUTIONS_ALL"."LAST_UPDATE_DATE"  >=  $G_SDATE ) AND ( "AP_INVOICE_DISTRIBUTIONS_ALL"."LAST_UPDATE_DATE"  <=  $G_EDATE ) AND ( "PO_HEADERS_ALL"."PO_HEADER_ID"  =  "PO_DISTRIBUTIONS_ALL"."PO_HEADER_ID" )