[Home] [Help]
1128: pawo.program_update_date
1129: FROM
1130: po_accrual_write_offs_all pawo,
1131: rcv_receiving_sub_ledger rrs,
1132: xla_distribution_links xld, --BUG#7275286
1133: rcv_transactions rt,
1134: po_headers_all poh
1135: ,cst_accrual_accounts ca --BUG#7528609
1136: ,PO_distributions_all pod
1255: financials_system_params_all fsp,
1256: gl_sets_of_books gsob,
1257: fnd_currencies fc,
1258: ap_ae_lines_all aal,
1259: xla_distribution_links xld
1260: ,cst_accrual_accounts ca
1261: WHERE pawo.org_id = p_operating_unit
1262: AND pawo.po_distribution_id IS NULL -- Misc Invoices
1263: AND pawo.transaction_source_code = 'AP'
1391: gl_sets_of_books gsob,
1392: fnd_currencies fc,
1393: ap_ae_lines_all aal,
1394: cst_accrual_accounts caa,
1395: xla_distribution_links xld
1396: WHERE pawo.org_id = p_operating_unit
1397: AND pawo.po_distribution_id IS NULL -- Misc Invoices
1398: AND pawo.transaction_source_code = 'AP'
1399: AND pawo.invoice_id IS NOT NULL
1538: gl_sets_of_books gsob,
1539: fnd_currencies fc,
1540: ap_ae_lines aal,
1541: cst_accrual_accounts caa,
1542: xla_distribution_links xld,
1543: xla_ae_lines xal
1544: WHERE pawo.org_id = p_operating_unit
1545: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
1546: AND pod.po_distribution_id = pawo.po_distribution_id
1706: gl_sets_of_books gsob,
1707: fnd_currencies fc,
1708: ap_ae_lines aal,
1709: cst_accrual_accounts caa,
1710: xla_distribution_links xld
1711: WHERE pawo.org_id = p_operating_unit
1712: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
1713: AND pod.po_distribution_id = pawo.po_distribution_id
1714: AND pra.po_release_id(+) = pod.po_release_id
1847: pawo.program_id,
1848: pawo.program_update_date
1849: FROM po_accrual_write_offs_all pawo,
1850: mtl_transaction_accounts mta,
1851: xla_distribution_links xld
1852: ,cst_accrual_accounts ca --BUG#7528609
1853: WHERE pawo.transaction_source_code = 'INV'
1854: AND pawo.org_id = p_operating_unit
1855: AND pawo.inv_transaction_id = mta.transaction_id
1961: --}
1962: FROM cst_write_offs cwo,
1963: po_accrual_write_offs_all pawo,
1964: mtl_transaction_accounts mta,
1965: xla_distribution_links xld,
1966: cst_accrual_accounts ca --BUG7528609
1967: WHERE pawo.org_id = p_operating_unit
1968: AND pawo.transaction_source_code ='INV'
1969: AND cwo.write_off_id = pawo.write_off_id
2050: po_accrual_write_offs_all pawo,
2051: po_lookup_codes plc,
2052: rcv_receiving_sub_ledger rrs,
2053: rcv_transactions rt,
2054: xla_distribution_links xld,
2055: cst_accrual_accounts ca --BUG#7528609
2056: WHERE pawo.org_id = p_operating_unit
2057: AND pawo.transaction_source_code = 'PO'
2058: AND cwo.write_off_id = pawo.write_off_id
2144: po_lookup_codes plc,
2145: ap_invoice_distributions_all aida,
2146: ap_ae_lines_all aal,
2147: cst_accrual_accounts ca, --BUG#7528609
2148: xla_distribution_links xld
2149: ,xla_ae_lines xlal --XLD AP <=> n XLA AE line AP with different GL Accounts
2150: ,financials_system_params_all fsp --BUG#13869348
2151: WHERE pawo.org_id = p_operating_unit
2152: AND fsp.org_id = p_operating_unit
2425: xal.ae_line_num,
2426: xdl.source_distribution_id_num_1
2427: FROM xla_ae_headers xah,
2428: xla_ae_lines xal,
2429: xla_distribution_links xdl,
2430: cst_accrual_accounts caa,
2431: financials_system_params_all fsp
2432: WHERE fsp.org_id = p_operating_unit
2433: AND caa.operating_unit_id = p_operating_unit
3658: rcv_receiving_sub_ledger rrs,
3659: xla_ae_headers xah,
3660: xla_ae_lines xal,
3661: xla_transaction_entities_upg xte,
3662: xla_distribution_links xdl,
3663: po_headers_all poh,
3664: po_lines_all pol,
3665: po_distributions_all pod,
3666: cst_accrual_accounts caa,
3779: gmf_xla_extract_lines gel,
3780: xla_ae_headers xah,
3781: xla_ae_lines xal,
3782: xla_transaction_entities_upg xte,
3783: xla_distribution_links xdl,
3784: po_headers_all poh,
3785: po_lines_all pol,
3786: po_distributions_all pod,
3787: cst_accrual_accounts caa,
3944: -- ap_invoice_distributions_all aida,
3945: --}
3946: xla_ae_headers xah,
3947: xla_ae_lines xal,
3948: xla_distribution_links xdl,
3949: po_lines_all pol,
3950: po_distributions_all pod,
3951: cst_accrual_accounts caa,
3952: financials_system_params_all fsp,