DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on RA_TERMS

Line 3192: ra_terms_tl terms

3188: FROM oe_blanket_headers_all headers,
3189: oe_blanket_headers_ext blnk_ext,
3190: hz_cust_site_uses_all shipto,
3191: hz_cust_site_uses_all invoiceto,
3192: ra_terms_tl terms
3193: where headers.header_id = l_transaction_id
3194: and headers.order_number = blnk_ext.order_number(+)
3195: and headers.ship_to_org_id = shipto.site_use_id(+)
3196: and shipto.site_use_code(+) = 'SHIP_TO'

Line 3514: ra_terms terms

3510: l_transactional_curr_code, l_payment_term
3511: FROM oe_order_headers_all headers,
3512: oe_ship_to_orgs_v shipto,
3513: HZ_CUST_SITE_USES_ALL invoiceto,
3514: ra_terms terms
3515: where headers.header_id = l_transaction_id
3516: and headers.SHIP_TO_ORG_ID = shipto.organization_id(+)
3517: and headers.INVOICE_TO_ORG_ID = invoiceto.SITE_USE_ID(+)
3518: and invoiceto.SITE_USE_CODE(+) = 'BILL_TO'