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.AP_ETAX_SERVICES_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 1811: DELETE FROM zx_itm_distributions_gt;

1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1808: END IF;
1809: --Print(l_api_name,l_debug_info);
1810: -----------------------------------------------------------------
1811: DELETE FROM zx_itm_distributions_gt;
1812:
1813: --Bug9436217
1814:
1815: --Bug#11674044 modified the query to improve the performance.

Line 10988: | ZX_ITM_DISTRIBUTIONS_GT

Line 11017: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;

11013: IS
11014: l_debug_info VARCHAR2(240);
11015: l_curr_calling_sequence VARCHAR2(4000);
11016:
11017: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;
11018: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
11019:
11020: -- Purchase Order Info
11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;

Line 11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;

11017: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;
11018: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
11019:
11020: -- Purchase Order Info
11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;

Line 11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;

11018: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
11019:
11020: -- Purchase Order Info
11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

Line 11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;

11019:
11020: -- Purchase Order Info
11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;

Line 11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

11020: -- Purchase Order Info
11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;

Line 11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;

11021: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

Line 11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;

11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;

Line 11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;

11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;

Line 11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;

11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;

Line 11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;

11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;

Line 11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;

11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;

Line 11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;

11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:

Line 11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;

11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:
11043: -- Correction Invoice Info

Line 11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;

11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:
11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

Line 11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;

11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:
11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

Line 11615: INSERT INTO zx_itm_distributions_gt

11611: -------------------------------------------------------------------
11612: IF (l_return_status = TRUE) THEN
11613:
11614: FORALL m IN trans_dists.FIRST..trans_dists.LAST
11615: INSERT INTO zx_itm_distributions_gt
11616: VALUES trans_dists(m);
11617:
11618: END IF;
11619: END IF;