[Home] [Help]
251: WHERE lines_gt.trx_business_category is NOT NULL
252: AND NOT EXISTS
253: (SELECT 1
254: FROM
255: zx_evnt_cls_mappings evntmap,
256: jl_zz_ar_tx_att_cls tac,
257: jl_zz_ar_tx_categ tc,
258: ar_system_parameters asp
259: where
303: (
304: SELECT 1
305: FROM
306: zx_trx_headers_gt header,
307: zx_evnt_cls_mappings evntmap,
308: FND_LOOKUPS LK,
309: JL_ZZ_AR_TX_FSC_CLS FSC
310: where
311: lines_gt.application_id = header.application_id
358: (
359: SELECT 1
360: FROM
361: zx_trx_headers_gt header,
362: zx_evnt_cls_mappings evntmap,
363: FND_LOOKUPS LK,
364: JL_ZZ_AR_TX_FSC_CLS FSC
365: where
366: lines_gt.application_id = header.application_id
752: Lines.trx_level_type
753: FROM
754: ZX_TRANSACTION_LINES_GT Lines ,
755: mtl_system_items items,
756: ZX_EVNT_CLS_MAPPINGS event
757: WHERE items.organization_id = lines.Product_org_id
758: AND items.inventory_item_id = lines.product_id
759: AND lines.product_org_id is not NULL
760: AND Lines.application_id = Event.application_id
785: Lines.trx_level_type
786: FROM
787: ZX_TRANSACTION_LINES_GT Lines ,
788: ar_memo_lines Memo,
789: ZX_EVNT_CLS_MAPPINGS event
790: WHERE Memo.memo_line_id = lines.product_id
791: AND lines.product_org_id is NULL
792: AND Lines.application_id = Event.application_id
793: AND Lines.entity_code = Event.entity_code
1780: END TAX_RATE_CODE_NOT_ACTIVE
1781:
1782: FROM
1783: ZX_TRX_HEADERS_GT header,
1784: ZX_EVNT_CLS_MAPPINGS evntmap,
1785: ZX_TRANSACTION_LINES_GT lines_gt,
1786: GL_SETS_OF_BOOKS gsob
1787:
1788: WHERE