DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on AR_MEMO_LINES

Line 659: -- Product Category from ar_memo_lines.

655:
656: -- In case where the line is not a memo line, default the Transaction Business
657: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
658: -- If the line is a memo line, then populate Transaction Business Category and
659: -- Product Category from ar_memo_lines.
660:
661: IF (g_level_statement >= g_current_runtime_level ) THEN
662: FND_LOG.STRING(g_level_statement,
663: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

Line 776: -- and Product Category from ar_memo_lines.

772: WHEN NOT MATCHED THEN
773: INSERT (LINE_AMT) VALUES(NULL);
774:
775: -- In case where the product type is 'MEMO', default the Transaction Business Category
776: -- and Product Category from ar_memo_lines.
777:
778: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
779: USING (SELECT
780: Event.tax_event_class_code,

Line 788: ar_memo_lines Memo,

784: Lines.trx_line_id,
785: Lines.trx_level_type
786: FROM
787: ZX_TRANSACTION_LINES_GT Lines ,
788: ar_memo_lines Memo,
789: ZX_EVNT_CLS_MAPPINGS event
790: WHERE Memo.memo_line_id = lines.product_id
791: AND lines.product_org_id is NULL
792: AND Lines.application_id = Event.application_id

Line 905: -- Product Category from ar_memo_lines.

901:
902: -- In case where the line is not a memo line, default the Transaction Business
903: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
904: -- If the line is a memo line, then populate Transaction Business Category and
905: -- Product Category from ar_memo_lines.
906:
907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
908:
909: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1021: -- and Product Category from ar_memo_lines.

1017: ELSIF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
1018: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NULL THEN
1019:
1020: -- In case where the line is a memo line, default the Transaction Business Category
1021: -- and Product Category from ar_memo_lines.
1022:
1023: IF (zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) IS NULL
1024: OR zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) IS NULL)
1025: then

Line 1045: ar_memo_lines Memo

1041: INTO
1042: l_trx_business_category,
1043: l_product_category
1044: FROM
1045: ar_memo_lines Memo
1046: WHERE memo_line_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
1047:
1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),