DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CS_TXN_BILLING_OETXN_ALL

Line 550: CS_TXN_BILLING_OETXN_ALL tb,

546: cbtc.billing_category,
547: edt.list_price , -- 4870210
548: i.item_type item_type_code --6523849
549: FROM CS_ESTIMATE_DETAILS edt,
550: CS_TXN_BILLING_OETXN_ALL tb,
551: CS_TXN_BILLING_TYPES tbt,
552: MTL_SYSTEM_ITEMS_KFV i,
553: CS_INCIDENTS_ALL_B sr,
554: CS_TRANSACTION_TYPES_B tt,

Line 600: CS_TXN_BILLING_OETXN_ALL tb,

596: p_purchase_order_num varchar2,p_txn_billing_type_id number,
597: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
598: SELECT nvl(max(edt.order_header_id),-999)
599: FROM CS_ESTIMATE_DETAILS edt,
600: CS_TXN_BILLING_OETXN_ALL tb,
601: OE_ORDER_HEADERS_ALL oe
602: WHERE edt.incident_id = p_incident_id AND
603: edt.currency_code = p_currency_code AND
604: nvl(edt.invoice_to_org_id,-999) = nvl(p_invoice_to_org_id,-999) AND