APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 89: and removed the Table pa_draft_invoice_items from the list to avoid the Cartesian join.

85: four tables are used.But the join conditions in the where clause are only three which might be
86: leading to a cartesain join on the queries fetched.
87: FIX:
88: Modified cursor c_get_pa_details, included an inline-select statement for the field document_line_desc
89: and removed the Table pa_draft_invoice_items from the list to avoid the Cartesian join.
90:
91: 18. 18-Feb-2010 Bgowrava for bug#9385880, File Version 120.19.12010000.11
92: Issue: INDIA - SERVICE TAX PROCESSING IS COMPLETED WITH WARNING
93: Fix: Added a IF condition in the procedure get_doc_from_reference

Line 1579: , (select substr(padil.text,1,240) from pa_draft_invoice_items padil

1575: , null document_line_item
1576: -- Modified by Jia for FP Bug#6691866, Begin
1577: -------------------------------------------------------------------------------------------------
1578: --, substr(padil.text,1,240) document_line_desc -- Comment by Jia for FP Bug#6691866
1579: , (select substr(padil.text,1,240) from pa_draft_invoice_items padil
1580: where padil.draft_invoice_num = jpadi.draft_invoice_num
1581: and padil.project_id =jpadi.project_id
1582: and padil.line_num = jpadil.line_num ) document_line_desc -- Added by Jia for FP Bug#6691866
1583: -------------------------------------------------------------------------------------------------

Line 1597: -- ,pa_draft_invoice_items padil Removed by Jia for FP Bug#6691866

1593: , jpadil.service_type_code service_type_code
1594: from
1595: PA_DRAFT_INVOICES_ALL padi,
1596: PA_PROJECTS_ALL p
1597: -- ,pa_draft_invoice_items padil Removed by Jia for FP Bug#6691866
1598: ,jai_pa_draft_invoices jpadi
1599: ,jai_pa_draft_invoice_lines jpadil
1600: ,PA_CUSTOMERS_V c
1601: where jpadi.draft_invoice_id = p_document_id