DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 245: oe_transaction_types_tl ott

241: p_order_type varchar2) IS
242: SELECT A.register_code
243: FROM JAI_OM_OE_BOND_REG_HDRS A,
244: JAI_OM_OE_BOND_REG_DTLS b,
245: oe_transaction_types_tl ott
246: WHERE A.organization_id = p_organization_id
247: AND A.location_id = p_location_id
248: AND A.register_id = b.register_id
249: AND b.order_flag = 'Y'

Line 280: OE_TRANSACTION_TYPES_TL ot,

276: pn_order_line_id NUMBER) IS
277: SELECT count(1)
278: FROM OE_ORDER_HEADERS_ALL oh,
279: OE_ORDER_LINES_ALL ol,
280: OE_TRANSACTION_TYPES_TL ot,
281: oe_workflow_assignments owf
282: WHERE oh.header_id = ol.header_id
283: AND oh.order_type_id = ot.transaction_type_id
284: AND oh.order_type_id = owf.order_type_id