1342: )
1343: )
1344: )
1345: )
1346: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1347: LNS_LOOKUPS lkps1 , fnd_lookups fl
1348: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1349: AND lkps1.lookup_type = 'CONDITION_TYPE'
1350: AND lkps1.lookup_code = lc.CONDITION_TYPE
1477: )
1478: )
1479: )
1480: )
1481: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1482: LNS_LOOKUPS lkps1 , fnd_lookups fl
1483: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1484: AND lkps1.lookup_type = 'CONDITION_TYPE'
1485: AND lkps1.lookup_code = lc.CONDITION_TYPE