APPS.PAAPIMP_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 892: FROM pa_expenditure_items_all ei

888: WHERE DIST.pa_addition_flag IN ('O','W')
889: AND DIST.posted_flag= 'Y' -- removed the append || '' for bug 13599091
890: AND DIST.project_id >0
891: AND NOT EXISTS ( SELECT 'X'
892: FROM pa_expenditure_items_all ei
893: WHERE ei.document_header_id = dist.invoice_id /*Added for bug 6327185 */
894: AND ei.document_distribution_id = dist.invoice_distribution_id
895: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;
896:

Line 906: FROM pa_expenditure_items_all ei

902: WHERE DIST.pa_addition_flag IN ('O','W')
903: AND DIST.posted_flag||''= 'Y'
904: AND DIST.project_id >0
905: AND NOT EXISTS ( SELECT 'X'
906: FROM pa_expenditure_items_all ei
907: WHERE ei.document_header_id = dist.invoice_id
908: AND ei.document_distribution_id = dist.invoice_distribution_id
909: AND ei.document_distribution_type = 'SELF_ASSESSED_TAX'
910: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;

Line 927: FROM pa_expenditure_items_all ei

923: FROM ap_payment_history_all hist
924: WHERE hist.payment_history_id = dist.payment_history_id
925: AND hist.posted_flag = 'Y')
926: AND NOT EXISTS ( SELECT /*+ push_subq no_unnest */ 'X' /* added hint for BUG 13002753 */
927: FROM pa_expenditure_items_all ei
928: WHERE ei.document_distribution_id = dist.invoice_distribution_id
929: AND ei.document_payment_id = dist.invoice_payment_id
930: AND ei.transaction_source = 'AP DISCOUNTS') ;
931:

Line 945: FROM pa_expenditure_items_all ei

941: SET rcv_sub.pa_addition_flag = 'N'
942: ,rcv_sub.request_id = G_REQUEST_ID
943: WHERE rcv_sub.pa_addition_flag = 'O'
944: AND NOT EXISTS (SELECT 'X'
945: FROM pa_expenditure_items_all ei
946: WHERE ei.document_distribution_id = rcv_sub.rcv_transaction_id);
947:
948: If g_body_debug_mode = 'Y' Then
949: write_log(LOG, 'Number of rcv txn cleaned up from O:' || to_char(SQL%ROWCOUNT));

Line 972: FROM pa_expenditure_items_all ei

968: FROM ap_payment_history_all hist
969: WHERE hist.payment_history_id = dist.payment_history_id
970: AND hist.posted_flag = 'Y')
971: AND NOT EXISTS ( SELECT 'X'
972: FROM pa_expenditure_items_all ei
973: WHERE ei.document_distribution_id = dist.invoice_distribution_id
974: AND ei.document_payment_id = dist.invoice_payment_id
975: AND ei.transaction_source = 'AP INVOICE') ;
976:

Line 986: FROM pa_expenditure_items_all ei

982: SET dist.pa_addition_flag = 'N',
983: request_id = G_REQUEST_ID
984: WHERE dist.pa_addition_flag = 'O'
985: AND NOT EXISTS ( SELECT 'X'
986: FROM pa_expenditure_items_all ei
987: WHERE ei.document_distribution_id = dist.invoice_distribution_id
988: AND ei.document_payment_id = dist.prepay_app_dist_id
989: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;
990:

Line 5309: UPDATE pa_expenditure_items_all exp1

5305:
5306: /* Bug 5440548 fix to update expenditure data with historical flag for historical AP data */
5307: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
5308:
5309: UPDATE pa_expenditure_items_all exp1
5310: SET historical_flag = 'Y'
5311: WHERE document_header_id = l_sys_ref2_tbl(i)
5312: AND document_distribution_id = l_sys_ref5_tbl(i)
5313: AND document_distribution_type <> 'SELF_ASSESSED_TAX' /*Bug 13602288: Self Assessed Tax Changes*/

Line 12827: pa_expenditure_items_all ei

12823: ,cdl.system_reference5 cdl_sys_ref5 --to get the rcv_sub_leger_id of parent Rcv txn
12824: ,ei.cbs_element_id -- Added for CBS Enhancement Bug 16220146
12825: /* ,nvl(ei.net_zero_adjustment_flag,'N') net_zero_adjustment_flag -- Added for for bug#12338132 Commented for 13470521 */
12826: FROM pa_cost_distribution_lines_all cdl,
12827: pa_expenditure_items_all ei
12828: WHERE cdl.expenditure_item_id (+) = ei.expenditure_item_id
12829: AND nvl(cdl.reversed_flag, 'N') = 'N'
12830: AND ei.document_distribution_id = p_document_distribution_id /*Added this for 6945767 */
12831: AND ei.system_linkage_function in ('VI','ER')

Line 13080: FROM pa_expenditure_items_all ei

13076: write_log(LOG, 'Selecting the count of adjusted expenditures');
13077:
13078: SELECT sum(decode(ei.net_zero_adjustment_flag,'N',1,0)),count(*)
13079: INTO l_not_reversed_cnt,l_all_reversed_cnt
13080: FROM pa_expenditure_items_all ei
13081: /*Added this for 6945767 */
13082: WHERE ei.document_distribution_id = p_document_distribution_id
13083: AND ei.document_header_id = p_document_header_id /*Added this for 6945767 */
13084: AND (( p_record_type = 'AP_INVOICE'

Line 13102: AND EXISTS (SELECT 1 FROM pa_expenditure_items_all adj_ei

13098: --AND ei.document_distribution_id = p_document_distribution_id
13099: AND ei.document_payment_id = p_document_payment_id
13100: AND ei.transaction_source in ('AP INVOICE','AP EXPENSE','AP VARIANCE','AP NRTAX')))
13101: /* Added below code for 13470521 */
13102: AND EXISTS (SELECT 1 FROM pa_expenditure_items_all adj_ei
13103: WHERE adj_ei.adjusted_expenditure_item_id = ei.expenditure_item_id
13104: AND adj_ei.net_zero_adjustment_flag = 'Y'
13105: AND adj_ei.document_header_id = ei.document_header_id
13106: AND adj_ei.document_distribution_id = ei.document_distribution_id);