DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_LANGUAGES

Line 1432: FROM fnd_languages

1428: AND TO_CHAR(ooh.order_number) = mso.segment1
1429: AND ooh.order_type_id = ott.transaction_type_id
1430: AND ott.name = mso.segment2
1431: AND ott.language = (SELECT language_code
1432: FROM fnd_languages
1433: WHERE installed_flag = 'B')
1434: AND mso.segment3 = l_source_code
1435: AND ccqa.adj_mmt_txn_id IS NOT NULL;
1436:

Line 2371: from fnd_languages

2367: AND to_char(ooh.order_number) = mkts.segment1
2368: AND ooh.order_type_id = ott.transaction_type_id
2369: AND ott.name = mkts.segment2
2370: AND ott.language = (select language_code
2371: from fnd_languages
2372: where installed_flag = 'B')
2373: AND mkts.segment3 = l_source_code);
2374:
2375:

Line 3333: FROM fnd_languages

3329: AND TO_CHAR(ooh.order_number) = mso.segment1
3330: AND ooh.order_type_id = ott.transaction_type_id
3331: AND ott.name = mso.segment2
3332: AND ott.language = (SELECT language_code
3333: FROM fnd_languages
3334: WHERE installed_flag = 'B')
3335: AND mso.segment3 = l_source_code
3336: --{BUG#6909721
3337: -- Ensure the place holder COGS event is not inserted in MMT as not effect on Cost and Accounting