DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on FND_LOOKUPS

Line 1631: FND_LOOKUPS fnd,

1627: ZX_FC_CODES_B fc_user,
1628: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
1629: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
1630: ZX_FC_CODES_B fc_int,
1631: FND_LOOKUPS fnd,
1632: FND_TERRITORIES fnd_terr,
1633: ZX_FC_PRODUCT_FISCAL_V fc_product
1634: --ZX_RATES_B rates --Commented for Bug#7504455--
1635:

Line 3642: (SELECT 1 FROM FND_LOOKUPS lkp

3638:
3639: -- Check for Validity of Transaction line class
3640: nvl2(lines_gt.line_class,
3641: CASE WHEN (NOT EXISTS
3642: (SELECT 1 FROM FND_LOOKUPS lkp
3643: WHERE lines_gt.line_class = lkp.lookup_code
3644: AND lkp.lookup_type = 'ZX_LINE_CLASS'))
3645: THEN 'Y'
3646: ELSE NULL

Line 4163: FND_LOOKUPS fnd,

4159: ZX_FC_CODES_B fc_user,
4160: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
4161: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
4162: ZX_FC_CODES_B fc_int,
4163: FND_LOOKUPS fnd,
4164: ZX_FC_PRODUCT_FISCAL_V fc_product
4165: --ZX_RATES_B rates --Commented for Bug#7504455--
4166: WHERE
4167: lines_gt.trx_id = header.trx_id