AP_MATCH_CORRECTION_DISTS

Details

Schema: FUSION
Object owner: AP
Object type: VIEW

Columns

Name
INVOICE_ID INVOICE_LINE_NUMBER INVOICE_DISTRIBUTION_ID DIST_QTY_INVOICED ACCRUAL_ACCOUNT_ID ACCRUED_FLAG ACCRUE_ON_RECEIPT_FLAG DELIVERED BILLED ORDERED AMOUNT_BILLED LINE_TYPE_LOOKUP_CODE ASSETS_TRACKING_FLAG ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY BOM_RESOURCE_ID BUDGET_ACCOUNT_ID CODE_COMBINATION_ID DELIVER_TO_LOCATION_ID DELIVER_TO_PERSON_ID DESTINATION_CONTEXT DESTINATION_ORGANIZATION_ID DESTINATION_SUBINVENTORY DESTINATION_TYPE_CODE DISTRIBUTION_NUM PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID EXPENDITURE_ORGANIZATION PJC_EXPENDITURE_TYPE_ID FAILED_FUNDS_LOOKUP_CODE GL_CANCELLED_DATE GL_CLOSED_DATE GL_ENCUMBERED_DATE GL_ENCUMBERED_PERIOD_NAME GOVERNMENT_CONTEXT LINE_LOCATION_ID ORG_ID PO_DISTRIBUTION_ID PO_HEADER_ID PO_LINE_ID PREVENT_ENCUMBRANCE_FLAG PROJECT_ACCOUNTING_CONTEXT PJC_PROJECT_ID PROJECT_NAME RATE RATE_DATE REQUEST_ID REQ_DISTRIBUTION_ID REQ_HEADER_REFERENCE_NUM REQ_LINE_REFERENCE_NUM SET_OF_BOOKS_ID SOURCE_DISTRIBUTION_ID PJC_TASK_ID UNENCUMBERED_AMOUNT UNENCUMBERED_QUANTITY VARIANCE_ACCOUNT_ID WIP_ENTITY_ID WIP_LINE_ID WIP_OPERATION_SEQ_NUM WIP_REPETITIVE_SCHEDULE_ID WIP_RESOURCE_SEQ_NUM REQUESTOR UOM_CODE PJC_CONTEXT_CATEGORY PJC_BILLABLE_FLAG PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 PJC_CONTRACT_ID PJC_WORK_TYPE_ID PJC_CAPITALIZABLE_FLAG PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_FUNDING_ALLOCATION_ID PJC_CONTRACT_LINE_ID AWT_GROUP_ID BUDGET_DATE DEF_ACCTG_START_DATE DEF_ACCTG_END_DATE DEF_ACCTG_ACCRUAL_CCID

Name

INVOICE_ID

INVOICE_LINE_NUMBER

INVOICE_DISTRIBUTION_ID

DIST_QTY_INVOICED

ACCRUAL_ACCOUNT_ID

ACCRUED_FLAG

ACCRUE_ON_RECEIPT_FLAG

DELIVERED

BILLED

ORDERED

AMOUNT_BILLED

LINE_TYPE_LOOKUP_CODE

ASSETS_TRACKING_FLAG

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

BOM_RESOURCE_ID

BUDGET_ACCOUNT_ID

CODE_COMBINATION_ID

DELIVER_TO_LOCATION_ID

DELIVER_TO_PERSON_ID

DESTINATION_CONTEXT

DESTINATION_ORGANIZATION_ID

DESTINATION_SUBINVENTORY

DESTINATION_TYPE_CODE

DISTRIBUTION_NUM

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

EXPENDITURE_ORGANIZATION

PJC_EXPENDITURE_TYPE_ID

FAILED_FUNDS_LOOKUP_CODE

GL_CANCELLED_DATE

GL_CLOSED_DATE

GL_ENCUMBERED_DATE

GL_ENCUMBERED_PERIOD_NAME

GOVERNMENT_CONTEXT

LINE_LOCATION_ID

ORG_ID

PO_DISTRIBUTION_ID

PO_HEADER_ID

PO_LINE_ID

PREVENT_ENCUMBRANCE_FLAG

PROJECT_ACCOUNTING_CONTEXT

PJC_PROJECT_ID

PROJECT_NAME

RATE

RATE_DATE

REQUEST_ID

REQ_DISTRIBUTION_ID

REQ_HEADER_REFERENCE_NUM

REQ_LINE_REFERENCE_NUM

SET_OF_BOOKS_ID

SOURCE_DISTRIBUTION_ID

PJC_TASK_ID

UNENCUMBERED_AMOUNT

UNENCUMBERED_QUANTITY

VARIANCE_ACCOUNT_ID

WIP_ENTITY_ID

WIP_LINE_ID

WIP_OPERATION_SEQ_NUM

WIP_REPETITIVE_SCHEDULE_ID

WIP_RESOURCE_SEQ_NUM

REQUESTOR

UOM_CODE

PJC_CONTEXT_CATEGORY

PJC_BILLABLE_FLAG

PJC_USER_DEF_ATTRIBUTE1

PJC_USER_DEF_ATTRIBUTE2

PJC_USER_DEF_ATTRIBUTE3

PJC_USER_DEF_ATTRIBUTE4

PJC_USER_DEF_ATTRIBUTE5

PJC_USER_DEF_ATTRIBUTE6

PJC_USER_DEF_ATTRIBUTE7

PJC_USER_DEF_ATTRIBUTE8

PJC_USER_DEF_ATTRIBUTE9

PJC_USER_DEF_ATTRIBUTE10

PJC_CONTRACT_ID

PJC_WORK_TYPE_ID

PJC_CAPITALIZABLE_FLAG

PJC_RESERVED_ATTRIBUTE1

PJC_RESERVED_ATTRIBUTE2

PJC_RESERVED_ATTRIBUTE3

PJC_RESERVED_ATTRIBUTE4

PJC_RESERVED_ATTRIBUTE5

PJC_RESERVED_ATTRIBUTE6

PJC_RESERVED_ATTRIBUTE7

PJC_RESERVED_ATTRIBUTE8

PJC_RESERVED_ATTRIBUTE9

PJC_RESERVED_ATTRIBUTE10

PJC_FUNDING_ALLOCATION_ID

PJC_CONTRACT_LINE_ID

AWT_GROUP_ID

BUDGET_DATE

DEF_ACCTG_START_DATE

DEF_ACCTG_END_DATE

DEF_ACCTG_ACCRUAL_CCID

Query

SQL_Statement
SELECT AID.INVOICE_ID INVOICE_ID , AID.INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER , AID.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID , AID.QUANTITY_INVOICED DIST_QTY_INVOICED , PD.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID , PD.ACCRUED_FLAG ACCRUED_FLAG , PD.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG , Decode(pll.matching_basis,'QUANTITY',pd.quantity_delivered,Nvl(pd.amount_delivered,0)) delivered, Decode(pll.matching_basis,'QUANTITY',pd.quantity_billed,Nvl(pd.amount_billed,0)) billed, Decode(pll.matching_basis,'QUANTITY',pd.quantity_ordered,Nvl(pd.amount_ordered,0)) ordered, pd.amount_billed amount_billed, AID.LINE_TYPE_LOOKUP_CODE line_type_lookup_code, AID.ASSETS_TRACKING_FLAG assets_tracking_flag, AID.ATTRIBUTE1 ATTRIBUTE1 , AID.ATTRIBUTE2 ATTRIBUTE2 , AID.ATTRIBUTE3 ATTRIBUTE3 , AID.ATTRIBUTE4 ATTRIBUTE4 , AID.ATTRIBUTE5 ATTRIBUTE5 , AID.ATTRIBUTE6 ATTRIBUTE6 , AID.ATTRIBUTE7 ATTRIBUTE7 , AID.ATTRIBUTE8 ATTRIBUTE8 , AID.ATTRIBUTE9 ATTRIBUTE9 , AID.ATTRIBUTE10 ATTRIBUTE10 , AID.ATTRIBUTE11 ATTRIBUTE11 , AID.ATTRIBUTE12 ATTRIBUTE12 , AID.ATTRIBUTE13 ATTRIBUTE13 , AID.ATTRIBUTE14 ATTRIBUTE14 , AID.ATTRIBUTE15 ATTRIBUTE15 , AID.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , PD.BOM_RESOURCE_ID BOM_RESOURCE_ID , PD.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID , NVL(AID.DIST_CODE_COMBINATION_ID,-1) CODE_COMBINATION_ID , /* bug#22778549 - made the field non-updateable / PD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID , PD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID , PD.DESTINATION_CONTEXT DESTINATION_CONTEXT , PD.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID , PD.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY , PD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE , PD.DISTRIBUTION_NUM DISTRIBUTION_NUM , AID.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE , AID.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID , (SELECT HROU.NAME FROM HR_ORG_UNITS_NO_JOIN HROU WHERE AID.PJC_ORGANIZATION_ID = HROU.ORGANIZATION_ID) EXPENDITURE_ORGANIZATION / Modified for bug#22652320 / , AID.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID , PD.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE , PD.GL_CANCELLED_DATE GL_CANCELLED_DATE , PD.GL_CLOSED_DATE GL_CLOSED_DATE , PD.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE , PD.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME , PD.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT , AIL.PO_LINE_LOCATION_ID LINE_LOCATION_ID , AID.ORG_ID ORG_ID , PD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID , PD.PO_HEADER_ID PO_HEADER_ID , PD.PO_LINE_ID PO_LINE_ID , PD.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG , null PROJECT_ACCOUNTING_CONTEXT , AID.PJC_PROJECT_ID PJC_PROJECT_ID , PAP.SEGMENT1 PROJECT_NAME , PD.RATE RATE , PD.RATE_DATE RATE_DATE , PD.REQUEST_ID REQUEST_ID , PD.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID , PD.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM , PD.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM , AID.SET_OF_BOOKS_ID SET_OF_BOOKS_ID , PD.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID , AID.PJC_TASK_ID PJC_TASK_ID , PD.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT , PD.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY , PD.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID , PD.WIP_ENTITY_ID WIP_ENTITY_ID , PD.WIP_LINE_ID WIP_LINE_ID , PD.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM , PD.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID , PD.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM , (select he.PERSON_ID from per_people_f he where pd.deliver_to_person_id = he.person_id AND TRUNC(sysdate) > TRUNC(he.effective_start_date) AND TRUNC(sysdate) < TRUNC(he.effective_end_date)) REQUESTOR, / Modified for bug#22652320 / PLL.UOM_CODE UOM_CODE, 'AP_Invoice_Distribution' PJC_CONTEXT_CATEGORY, AID.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, AID.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1, AID.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, AID.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, AID.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, AID.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, AID.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, AID.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, AID.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, AID.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, AID.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10, AID.PJC_CONTRACT_ID PJC_CONTRACT_ID, AID.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, AID.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, AID.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, AID.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, AID.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, AID.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, AID.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, AID.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, AID.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, AID.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, AID.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, AID.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, AID.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, AID.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID , AID.AWT_GROUP_ID, AID.BUDGET_DATE, AID.DEF_ACCTG_START_DATE, AID.DEF_ACCTG_END_DATE, AID.DEF_ACCTG_ACCRUAL_CCID FROM AP_INVOICE_LINES_ALL AIL , AP_INVOICE_DISTRIBUTIONS_ALL AID, PO_DISTRIBUTIONS_ALL PD , / PER_PEOPLE_F HE , PJF_PROJECTS_ALL_B PAP , /* Commented HR views for bug#22652320 HR_ORG_UNITS_NO_JOIN HROU , HR_ALL_ORGANIZATION_UNITS_TL HOUT, / po_line_locations_all pll WHERE AIL.INVOICE_ID = AID.INVOICE_ID AND AIL.LINE_NUMBER = AID.INVOICE_LINE_NUMBER AND (AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM', 'ACCRUAL') AND AID.PREPAY_DISTRIBUTION_ID IS NULL) AND AIL.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID AND AID.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID / Commented joins with HR views for bug#PER view AND PD.DELIVER_TO_PERSON_ID = HE.PERSON_ID (+) AND TRUNC(SYSDATE) > trunc(HE.EFFECTIVE_START_DATE (+)) AND TRUNC(SYSDATE) < trunc(HE.EFFECTIVE_END_DATE (+)) / AND AID.PJC_PROJECT_ID = PAP.PROJECT_ID (+) / Commented joins with HR views for bug#22652320 AND AID.PJC_ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND hrou.organization_id = hout.organization_id (+) AND DECODE(hout.organization_id, NULL, '1', hout.language) = DECODE(hout.organization_id, NULL, '1', USERENV('LANG')) */ AND pd.LINE_LOCATION_ID = pll.LINE_LOCATION_ID

SQL_Statement

SELECT AID.INVOICE_ID INVOICE_ID ,

AID.INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER ,

AID.INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID ,

AID.QUANTITY_INVOICED DIST_QTY_INVOICED ,

PD.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID ,

PD.ACCRUED_FLAG ACCRUED_FLAG ,

PD.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG ,

Decode(pll.matching_basis,'QUANTITY',pd.quantity_delivered,Nvl(pd.amount_delivered,0)) delivered,

Decode(pll.matching_basis,'QUANTITY',pd.quantity_billed,Nvl(pd.amount_billed,0)) billed,

Decode(pll.matching_basis,'QUANTITY',pd.quantity_ordered,Nvl(pd.amount_ordered,0)) ordered,

pd.amount_billed amount_billed,

AID.LINE_TYPE_LOOKUP_CODE line_type_lookup_code,

AID.ASSETS_TRACKING_FLAG assets_tracking_flag,

AID.ATTRIBUTE1 ATTRIBUTE1 ,

AID.ATTRIBUTE2 ATTRIBUTE2 ,

AID.ATTRIBUTE3 ATTRIBUTE3 ,

AID.ATTRIBUTE4 ATTRIBUTE4 ,

AID.ATTRIBUTE5 ATTRIBUTE5 ,

AID.ATTRIBUTE6 ATTRIBUTE6 ,

AID.ATTRIBUTE7 ATTRIBUTE7 ,

AID.ATTRIBUTE8 ATTRIBUTE8 ,

AID.ATTRIBUTE9 ATTRIBUTE9 ,

AID.ATTRIBUTE10 ATTRIBUTE10 ,

AID.ATTRIBUTE11 ATTRIBUTE11 ,

AID.ATTRIBUTE12 ATTRIBUTE12 ,

AID.ATTRIBUTE13 ATTRIBUTE13 ,

AID.ATTRIBUTE14 ATTRIBUTE14 ,

AID.ATTRIBUTE15 ATTRIBUTE15 ,

AID.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY ,

PD.BOM_RESOURCE_ID BOM_RESOURCE_ID ,

PD.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID ,

NVL(AID.DIST_CODE_COMBINATION_ID,-1) CODE_COMBINATION_ID , /* bug#22778549 - made the field non-updateable */

PD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID ,

PD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID ,

PD.DESTINATION_CONTEXT DESTINATION_CONTEXT ,

PD.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID ,

PD.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY ,

PD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE ,

PD.DISTRIBUTION_NUM DISTRIBUTION_NUM ,

AID.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE ,

AID.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID ,

(SELECT HROU.NAME FROM HR_ORG_UNITS_NO_JOIN HROU WHERE AID.PJC_ORGANIZATION_ID = HROU.ORGANIZATION_ID) EXPENDITURE_ORGANIZATION /* Modified for bug#22652320 */ ,

AID.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID ,

PD.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE ,

PD.GL_CANCELLED_DATE GL_CANCELLED_DATE ,

PD.GL_CLOSED_DATE GL_CLOSED_DATE ,

PD.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE ,

PD.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME ,

PD.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT ,

AIL.PO_LINE_LOCATION_ID LINE_LOCATION_ID ,

AID.ORG_ID ORG_ID ,

PD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID ,

PD.PO_HEADER_ID PO_HEADER_ID ,

PD.PO_LINE_ID PO_LINE_ID ,

PD.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG ,

null PROJECT_ACCOUNTING_CONTEXT ,

AID.PJC_PROJECT_ID PJC_PROJECT_ID ,

PAP.SEGMENT1 PROJECT_NAME ,

PD.RATE RATE ,

PD.RATE_DATE RATE_DATE ,

PD.REQUEST_ID REQUEST_ID ,

PD.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID ,

PD.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM ,

PD.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM ,

AID.SET_OF_BOOKS_ID SET_OF_BOOKS_ID ,

PD.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID ,

AID.PJC_TASK_ID PJC_TASK_ID ,

PD.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT ,

PD.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY ,

PD.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID ,

PD.WIP_ENTITY_ID WIP_ENTITY_ID ,

PD.WIP_LINE_ID WIP_LINE_ID ,

PD.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM ,

PD.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID ,

PD.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM ,

(select he.PERSON_ID from per_people_f he where pd.deliver_to_person_id = he.person_id AND TRUNC(sysdate) > TRUNC(he.effective_start_date) AND TRUNC(sysdate) < TRUNC(he.effective_end_date)) REQUESTOR, /* Modified for bug#22652320 */

PLL.UOM_CODE UOM_CODE,

'AP_Invoice_Distribution' PJC_CONTEXT_CATEGORY,

AID.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG,

AID.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1,

AID.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2,

AID.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3,

AID.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4,

AID.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5,

AID.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6,

AID.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7,

AID.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8,

AID.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9,

AID.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10,

AID.PJC_CONTRACT_ID PJC_CONTRACT_ID,

AID.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID,

AID.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG,

AID.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1,

AID.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2,

AID.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3,

AID.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4,

AID.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5,

AID.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6,

AID.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7,

AID.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8,

AID.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9,

AID.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10,

AID.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID,

AID.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID ,

AID.AWT_GROUP_ID,

AID.BUDGET_DATE,

AID.DEF_ACCTG_START_DATE,

AID.DEF_ACCTG_END_DATE,

AID.DEF_ACCTG_ACCRUAL_CCID

FROM AP_INVOICE_LINES_ALL AIL ,

AP_INVOICE_DISTRIBUTIONS_ALL AID,

PO_DISTRIBUTIONS_ALL PD ,

/* PER_PEOPLE_F HE ,

PJF_PROJECTS_ALL_B PAP ,

/* Commented HR views for bug#22652320

HR_ORG_UNITS_NO_JOIN HROU ,

HR_ALL_ORGANIZATION_UNITS_TL HOUT, */

po_line_locations_all pll

WHERE AIL.INVOICE_ID = AID.INVOICE_ID

AND AIL.LINE_NUMBER = AID.INVOICE_LINE_NUMBER

AND (AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM', 'ACCRUAL')

AND AID.PREPAY_DISTRIBUTION_ID IS NULL)

AND AIL.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID

AND AID.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID

/* Commented joins with HR views for bug#PER view

AND PD.DELIVER_TO_PERSON_ID = HE.PERSON_ID (+)

AND TRUNC(SYSDATE) > trunc(HE.EFFECTIVE_START_DATE (+))

AND TRUNC(SYSDATE) < trunc(HE.EFFECTIVE_END_DATE (+)) */

AND AID.PJC_PROJECT_ID = PAP.PROJECT_ID (+)

/* Commented joins with HR views for bug#22652320

AND AID.PJC_ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)

AND hrou.organization_id = hout.organization_id (+)

AND DECODE(hout.organization_id, NULL, '1', hout.language) = DECODE(hout.organization_id, NULL, '1', USERENV('LANG')) */

AND pd.LINE_LOCATION_ID = pll.LINE_LOCATION_ID