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_ALL

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 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 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,