eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAP_PWP_PKG dependencies on PA_PWP_LINKED_INVOICES

Line 845: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP

841:
842: -- Cursor C4 is to identify the Manually/Automatically linked draft invoices to a supplier invoice.
843: Cursor C4(P_Invoice_Id Number, P_Project_Id Number) Is
844: Select distinct draft_invoice_num,link_type From (
845: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP
846: Where PWP.AP_INVOICE_ID = p_invoice_id
847: And PWP.PROJECT_ID = p_project_id
848: UNION ALL
849: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,

Line 870: Select AP_Invoice_Id Invoice_Id From PA_PWP_LINKED_INVOICES PWP

866:
867: --Cursor C6 is to get all the linked invoices for a given Draft_Inv_Num
868: Cursor C6(P_Draft_Inv_Num Number) IS
869: Select distinct Invoice_Id From (
870: Select AP_Invoice_Id Invoice_Id From PA_PWP_LINKED_INVOICES PWP
871: Where PWP.draft_invoice_num = P_Draft_Inv_Num
872: And PWP.PROJECT_ID = p_project_id
873: And ap_Invoice_Id is not null
874: UNION ALL