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:
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
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