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.PA_MASS_ADDITIONS_CREATE_PKG dependencies on PA_COST_DISTRIBUTION_LINES

Line 243: from pa_cost_distribution_lines_all cdl2

239: apd.dist_code_combination_id,
240: apd.invoice_line_number ,
241: decode(cdl.reversed_flag, NULL, NULL,
242: ( select cdl2.si_assets_addition_flag
243: from pa_cost_distribution_lines_all cdl2
244: where cdl2.expenditure_item_id = cdl.expenditure_item_id
245: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
246: decode(cdl.line_num_reversed, NULL, NULL,
247: ( select cdl2.si_assets_addition_flag

Line 248: from pa_cost_distribution_lines_all cdl2

244: where cdl2.expenditure_item_id = cdl.expenditure_item_id
245: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
246: decode(cdl.line_num_reversed, NULL, NULL,
247: ( select cdl2.si_assets_addition_flag
248: from pa_cost_distribution_lines_all cdl2
249: where cdl2.expenditure_item_id = cdl.expenditure_item_id
250: and cdl2.line_num = cdl.line_num_reversed ) ) source_assets_flag,
251: DECODE(apd.line_type_lookup_code,
252: 'ITEM', decode( apd.corrected_invoice_dist_id,

Line 270: pa_cost_distribution_lines cdl,

266: fsp.inventory_organization_id,
267: apd.assets_tracking_flag
268: from pa_expenditure_items ei,
269: pa_expenditure_comments eic,
270: pa_cost_distribution_lines cdl,
271: ap_invoices api,
272: ap_batches_all apb,
273: ap_invoice_lines apil,
274: ap_invoice_distributions apd,

Line 642: UPDATE pa_cost_distribution_lines

638: IF Flag_no_eiIDTab.COUNT > 0 THEN
639:
640: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'Count of cdls ignored:'||Flag_no_eiIDTab.COUNT ) ;
641: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
642: UPDATE pa_cost_distribution_lines
643: SET si_assets_addition_flag = 'N',
644: program_update_date = SYSDATE,
645: program_application_id = FND_GLOBAL.prog_appl_id,
646: program_id = FND_GLOBAL.conc_program_id,

Line 901: from pa_cost_distribution_lines_all cdl2

897: apd.dist_code_combination_id,
898: apd.invoice_line_number,
899: decode(cdl.reversed_flag, NULL, NULL,
900: ( select cdl2.si_assets_addition_flag
901: from pa_cost_distribution_lines_all cdl2
902: where cdl2.expenditure_item_id = cdl.expenditure_item_id
903: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
904: decode(cdl.line_num_reversed, NULL, NULL,
905: ( select cdl2.si_assets_addition_flag

Line 906: from pa_cost_distribution_lines_all cdl2

902: where cdl2.expenditure_item_id = cdl.expenditure_item_id
903: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
904: decode(cdl.line_num_reversed, NULL, NULL,
905: ( select cdl2.si_assets_addition_flag
906: from pa_cost_distribution_lines_all cdl2
907: where cdl2.expenditure_item_id = cdl.expenditure_item_id
908: and cdl2.line_num = cdl.line_num_reversed ) ) source_assets_flag,
909: DECODE(apd.line_type_lookup_code,
910: 'ITEM', decode(apd.corrected_invoice_dist_id,

Line 927: pa_cost_distribution_lines cdl,

923: fsp.inventory_organization_id,
924: apd.assets_tracking_flag
925: from pa_expenditure_items ei,
926: pa_expenditure_comments eic,
927: pa_cost_distribution_lines cdl,
928: ap_invoices api,
929: ap_invoice_lines apil,
930: ap_invoice_distributions apd,
931: financials_system_params_all fsp,

Line 1259: UPDATE pa_cost_distribution_lines

1255: IF Flag_no_eiIDTab.COUNT > 0 THEN
1256: write_to_log(FND_LOG.LEVEL_STATEMENT, '40:INSERT_DISCOUNTS', 'Flag_no_eiIDTab.COUNT:'||Flag_no_eiIDTab.COUNT) ;
1257:
1258: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
1259: UPDATE pa_cost_distribution_lines
1260: SET si_assets_addition_flag = 'N',
1261: program_update_date = SYSDATE,
1262: program_application_id = FND_GLOBAL.prog_appl_id,
1263: program_id = FND_GLOBAL.conc_program_id,

Line 1489: UPDATE pa_cost_distribution_lines

1485: END IF;
1486:
1487: -- Successfully assets generated transactions
1488: --
1489: UPDATE pa_cost_distribution_lines
1490: SET si_assets_addition_flag = 'Y',
1491: program_update_date = SYSDATE,
1492: program_application_id = FND_GLOBAL.prog_appl_id,
1493: program_id = FND_GLOBAL.conc_program_id,

Line 1510: UPDATE pa_cost_distribution_lines

1506: -- Waiting for FA team Feedback and the condition...????
1507: --
1508: -- Rejected assets generated transactions
1509: --
1510: UPDATE pa_cost_distribution_lines
1511: SET si_assets_addition_flag = 'N',
1512: program_update_date = SYSDATE,
1513: program_application_id = FND_GLOBAL.prog_appl_id,
1514: program_id = FND_GLOBAL.conc_program_id,

Line 1560: select /+ leading(algt cdl) index(cdl PA_COST_DISTRIBUTION_LINES_N20) / ei.expenditure_item_id, /* 12320402 //14238526*/

1556:
1557: --
1558:
1559: cursor c_apinv is
1560: select /*+ leading(algt cdl) index(cdl PA_COST_DISTRIBUTION_LINES_N20) */ ei.expenditure_item_id, /* 12320402 *//*14238526*/
1561: ei.expenditure_item_date ,
1562: cdl.line_num,
1563: ei.document_header_id,
1564: ei.document_distribution_id,

Line 1601: from pa_cost_distribution_lines_all cdl2

1597: NULL, --dist_code_combination_id,
1598: NULL, --apd.invoice_line_number
1599: decode(cdl.reversed_flag, NULL, NULL,
1600: ( select cdl2.si_assets_addition_flag
1601: from pa_cost_distribution_lines_all cdl2
1602: where cdl2.expenditure_item_id = cdl.expenditure_item_id
1603: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
1604: decode(cdl.line_num_reversed, NULL, NULL,
1605: ( select cdl2.si_assets_addition_flag

Line 1606: from pa_cost_distribution_lines_all cdl2

1602: where cdl2.expenditure_item_id = cdl.expenditure_item_id
1603: and cdl2.line_num_reversed = cdl.line_num ) ) reversed_assets_flag,
1604: decode(cdl.line_num_reversed, NULL, NULL,
1605: ( select cdl2.si_assets_addition_flag
1606: from pa_cost_distribution_lines_all cdl2
1607: where cdl2.expenditure_item_id = cdl.expenditure_item_id
1608: and cdl2.line_num = cdl.line_num_reversed ) ) source_assets_flag,
1609: NULL parent_invoice_dist_id,
1610: 'Y' txn_assets_addition_flag,

Line 1616: from pa_cost_distribution_lines cdl,

1612: xal.code_combination_id,
1613: algt.ledger_category_code,
1614: algt.ledger_id,
1615: fsp.inventory_organization_id
1616: from pa_cost_distribution_lines cdl,
1617: --xla_ae_headers xah, /* 12320402 */
1618: xla_ae_lines xal,
1619: xla_distribution_links xdl,
1620: pa_expenditure_items ei,

Line 1870: UPDATE pa_cost_distribution_lines

1866: write_to_log(FND_LOG.LEVEL_STATEMENT, '50:PA INSERT_RECEIPT',
1867: 'Flag_no_eiIDTab.COUNT:'||Flag_no_eiIDTab.COUNT ) ;
1868:
1869: FORALL i in Flag_no_eiIDTab.FIRST..Flag_no_eiIDTab.LAST
1870: UPDATE pa_cost_distribution_lines
1871: SET si_assets_addition_flag = 'N',
1872: program_update_date = SYSDATE,
1873: program_application_id = FND_GLOBAL.prog_appl_id,
1874: program_id = FND_GLOBAL.conc_program_id,