DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 2167: OE_TRANSACTION_TYPES_TL ot,

2163: IS
2164: SELECT count(1)
2165: FROM OE_ORDER_HEADERS_ALL oh,
2166: OE_ORDER_LINES_ALL ol,
2167: OE_TRANSACTION_TYPES_TL ot,
2168: oe_workflow_assignments owf
2169: WHERE oh.header_id = ol.header_id
2170: AND oh.order_type_id = ot.transaction_type_id
2171: AND oh.order_type_id = owf.order_type_id

Line 2286: oe_transaction_types_tl ot,

2282: CURSOR get_copy_vat_invoice_cur
2283: IS
2284: SELECT jwl.vat_invoice_no
2285: FROM OE_ORDER_HEADERS_ALL ohc,
2286: oe_transaction_types_tl ot,
2287: JAI_OM_WSH_LINES_ALL jwl
2288: WHERE ohc.order_type_id = ot.transaction_type_id
2289: AND ot.LANGUAGE = userenv('LANG')
2290: AND ohc.source_document_id = jwl.ORDER_HEADER_ID