APPS.JL_ZZ_RECEIV_INTERFACE dependencies on JL_ZZ_AR_TX_FSC_CLS_ALL

Line 1070: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1066: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1067: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1068: AND EXISTS
1069: (SELECT 1
1070: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1071: WHERE fiscal_classification_code = fc.classification_code
1072: AND org_id = l_org_id
1073: AND enabled_flag = 'Y')
1074: AND ROWNUM =1;

Line 1105: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1101: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1102: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1103: AND EXISTS
1104: (SELECT 1
1105: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1106: WHERE fiscal_classification_code = fc.classification_code
1107: AND org_id = l_org_id
1108: AND enabled_flag = 'Y')
1109: AND ROWNUM =1;

Line 1209: c_org_id JL_ZZ_AR_TX_FSC_CLS_ALL.org_id%TYPE

1205: CURSOR c_get_fsc
1206: (c_country_code ZX_FC_CODES_B.country_code%TYPE,
1207: c_inventory_item_id MTL_ITEM_CATEGORIES.inventory_item_id%TYPE,
1208: c_inventory_org_id MTL_ITEM_CATEGORIES.organization_id%TYPE,
1209: c_org_id JL_ZZ_AR_TX_FSC_CLS_ALL.org_id%TYPE
1210: )
1211: IS
1212: SELECT fc.classification_code
1213: FROM zx_fc_product_fiscal_v fc,

Line 1229: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1225: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1226: AND rownum = 1
1227: AND EXISTS
1228: (SELECT 1
1229: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1230: WHERE fiscal_classification_code = fc.classification_code
1231: AND org_id = c_org_id
1232: AND enabled_flag = 'Y');
1233:

Line 1384: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1380: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1381: AND rownum = 1
1382: AND EXISTS
1383: (SELECT 1
1384: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1385: WHERE fiscal_classification_code = fc.classification_code
1386: AND org_id = l_org_id
1387: AND enabled_flag = 'Y');
1388: EXCEPTION

Line 1417: FROM JL_ZZ_AR_TX_FSC_CLS_ALL

1413: -- AND fc.structure_name = 'Fiscal Classification' -- Commented for Bug#7125709
1414: AND fc.structure_code = 'FISCAL_CLASSIFICATION' -- Added as a fix for Bug#7125709
1415: AND EXISTS
1416: (SELECT 1
1417: FROM JL_ZZ_AR_TX_FSC_CLS_ALL
1418: WHERE fiscal_classification_code = fc.classification_code
1419: AND org_id = l_org_id
1420: AND enabled_flag = 'Y')
1421: AND ROWNUM =1;