DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_LANGUAGES

Line 1251: FROM fnd_languages

1247: AND TO_CHAR(ooh.order_number) = mso.segment1
1248: AND ooh.order_type_id = ott.transaction_type_id
1249: AND ott.name = mso.segment2
1250: AND ott.language = (SELECT language_code
1251: FROM fnd_languages
1252: WHERE installed_flag = 'B')
1253: AND mso.segment3 = l_source_code
1254: AND ccqa.adj_mmt_txn_id IS NOT NULL;
1255:

Line 2323: from fnd_languages

2319: AND to_char(ooh.order_number) = mkts.segment1
2320: AND ooh.order_type_id = ott.transaction_type_id
2321: AND ott.name = mkts.segment2
2322: AND ott.language = (select language_code
2323: from fnd_languages
2324: where installed_flag = 'B')
2325: AND mkts.segment3 = l_source_code);
2326:
2327:

Line 3307: FROM fnd_languages

3303: AND TO_CHAR(ooh.order_number) = mso.segment1
3304: AND ooh.order_type_id = ott.transaction_type_id
3305: AND ott.name = mso.segment2
3306: AND ott.language = (SELECT language_code
3307: FROM fnd_languages
3308: WHERE installed_flag = 'B')
3309: AND mso.segment3 = l_source_code
3310: --{BUG#6909721
3311: -- Ensure the place holder COGS event is not inserted in MMT as not effect on Cost and Accounting