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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on JL_BR_SPED_PARTIC_REL

Line 1270: WHERE EXISTS ( SELECT 1 FROM jl_br_sped_partic_rel rel

1266: BEGIN
1267: SELECT 1 --if no data found means, no active relation in the report period.
1268: INTO l_partic_active_flag
1269: FROM dual
1270: WHERE EXISTS ( SELECT 1 FROM jl_br_sped_partic_rel rel
1271: WHERE rel.LEGAL_ENTITY_ID = g_legal_entity_id
1272: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1273: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify
1274: AND rel.participant_code = l_participant_code

Line 1306: FROM jl_br_sped_partic_rel rel

1302: ,'GL_BALANCING',g_bsv_segment
1303: ,'FA_COST_CTR',g_cost_center_segment)) = pc.flex_value
1304: ---,g_estb_segment_type,g_establishment_segment)) = pc.flex_value
1305: AND EXISTS (SELECT 1
1306: FROM jl_br_sped_partic_rel rel
1307: WHERE rel.LEGAL_ENTITY_ID = g_legal_entity_id
1308: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1309: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify
1310: AND rel.participant_code = pc.participant_code

Line 1381: FROM jl_br_sped_partic_rel rel

1377: WHERE vendor_id = l_third_party_id
1378: AND participant_type = 'SUPPLIERS'
1379: AND enabled_flag = 'Y'
1380: AND EXISTS (SELECT 1
1381: FROM jl_br_sped_partic_rel rel
1382: WHERE rel.participant_code = pc.participant_code
1383: AND legal_entity_id = g_legal_entity_id
1384: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1385: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify

Line 1417: FROM jl_br_sped_partic_rel rel

1413: AND vendor_site_id = l_third_party_site_id
1414: AND participant_type = 'SUPPLIER_SITES'
1415: AND enabled_flag = 'Y'
1416: AND EXISTS (SELECT 1
1417: FROM jl_br_sped_partic_rel rel
1418: WHERE rel.participant_code = pc.participant_code
1419: AND legal_entity_id = g_legal_entity_id
1420: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1421: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify

Line 1454: FROM jl_br_sped_partic_rel rel

1450: FROM jl_br_sped_partic_codes pc
1451: WHERE pc.cust_account_id = l_third_party_id
1452: AND pc.participant_type = 'CUSTOMERS'
1453: AND EXISTS (SELECT 1
1454: FROM jl_br_sped_partic_rel rel
1455: WHERE rel.participant_code = pc.participant_code
1456: AND legal_entity_id = g_legal_entity_id
1457: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1458: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify

Line 1491: FROM jl_br_sped_partic_rel rel

1487: -- AND pc.cust_account_id = l_third_party_id
1488: AND hcsu.site_use_id = l_third_party_site_id
1489: AND pc.participant_type = 'CUSTOMER_SITES'
1490: AND EXISTS (SELECT 1
1491: FROM jl_br_sped_partic_rel rel
1492: WHERE rel.participant_code = pc.participant_code
1493: AND legal_entity_id = g_legal_entity_id
1494: AND ((l_estb_acts_as_company ='Y' AND establishment_id=g_establishment_id)
1495: OR (l_estb_acts_as_company='N' AND establishment_id is null)) --- Need to modify

Line 2772: AND exists (select 1 from jl_br_sped_partic_rel rel

2768: (g_participant_type = 'SUPPLIERS_AND_CUSTOMERS' AND participant_type = 'SUPPLIERS') OR
2769: (g_participant_type = 'SUPPLIERS_AND_CUSTOMERS' AND participant_type = 'CUSTOMERS') OR
2770: (g_participant_type = 'SUPPLIER_AND_CUSTOMER_SITES' AND participant_type = 'SUPPLIER_SITES') OR
2771: (g_participant_type = 'SUPPLIER_AND_CUSTOMER_SITES' AND participant_type = 'CUSTOMER_SITES') )
2772: AND exists (select 1 from jl_br_sped_partic_rel rel
2773: where rel.participant_code = p.participant_code
2774: and rel.legal_entity_id = g_legal_entity_id
2775: and ((g_accounting_type='CENTRALIZED' AND ((l_estb_acts_as_company = 'Y' AND establishment_id = g_establishment_id)
2776: OR (l_estb_acts_as_company ='N' AND establishment_id is null)))

Line 2898: FROM jl_br_sped_partic_rel

2894: ,g_creation_date
2895: ,g_last_updated_by
2896: ,g_last_update_date
2897: ,g_last_update_login
2898: FROM jl_br_sped_partic_rel
2899: WHERE participant_code = partic_record.participant_code
2900: AND legal_entity_id = g_legal_entity_id
2901: AND ((l_estb_acts_as_company = 'Y' AND establishment_id = g_establishment_id)
2902: OR (l_estb_acts_as_company = 'N' AND establishment_id is null))