DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on AR_MEMO_LINES_ALL_B

Line 4676: UPDATE ar_memo_lines_all_b

4672: -- global_attribute1 only if it is null
4673: --
4674: -- If Hungary is installed then migrate Statistical Code GDF
4675: IF Is_Country_Installed(7002, 'jehuloc') THEN
4676: UPDATE ar_memo_lines_all_b
4677: SET tax_product_category = global_attribute1
4678: WHERE global_attribute_category = 'JE.HU.ARXSTDML.STAT_CODE'
4679: AND tax_product_category IS NULL;
4680: END IF;

Line 4684: UPDATE ar_memo_lines_all_b

4680: END IF;
4681:
4682: -- If Poland is installed then migrate Statistical Code GDF
4683: IF Is_Country_Installed(7002, 'jeplloc') THEN
4684: UPDATE ar_memo_lines_all_b
4685: SET tax_product_category = substrb(global_attribute1,1,48)
4686: WHERE global_attribute_category = 'JE.PL.ARXSTDML.STAT_CODE'
4687: AND tax_product_category IS NULL;
4688: END IF;

Line 4692: UPDATE ar_memo_lines_all_b

4688: END IF;
4689:
4690: -- If Argentina is installed then migrate Fiscal Classification Code GDF
4691: IF Is_Country_Installed(7004, 'jlarloc') THEN
4692: UPDATE ar_memo_lines_all_b
4693: SET tax_product_category = global_attribute1
4694: WHERE global_attribute_category = 'JL.AR.ARXSTDML.AR_MEMO_LINES'
4695: AND tax_product_category IS NULL;
4696: END IF;

Line 4700: UPDATE ar_memo_lines_all_b

4696: END IF;
4697:
4698: -- If Brazil is installed then migrate Fiscal Classification Code GDF
4699: IF Is_Country_Installed(7004, 'jlbrloc')THEN
4700: UPDATE ar_memo_lines_all_b
4701: SET tax_product_category = global_attribute1
4702: WHERE global_attribute_category = 'JL.BR.ARXSDML.Additional'
4703: AND tax_product_category IS NULL;
4704: END IF;

Line 4708: UPDATE ar_memo_lines_all_b

4704: END IF;
4705:
4706: -- If Colombia is installed then migrate Fiscal Classification Code GDF
4707: IF Is_Country_Installed(7004, 'jlcoloc') THEN
4708: UPDATE ar_memo_lines_all_b
4709: SET tax_product_category = global_attribute1
4710: WHERE global_attribute_category = 'JL.CO.ARXSTDML.AR_MEMO_LINES'
4711: AND tax_product_category IS NULL;
4712: END IF;