DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CS_TXN_BILLING_OETXN_ALL

Line 583: CS_TXN_BILLING_OETXN_ALL tb,

579: edt.no_charge_flag, -- bug 12907768,
580: edt.project_id, --12.2.2 Service Projects Integration
581: edt.project_task_id --12.2.2 Service Projects Integration
582: FROM CS_ESTIMATE_DETAILS edt,
583: CS_TXN_BILLING_OETXN_ALL tb,
584: CS_TXN_BILLING_TYPES tbt,
585: MTL_SYSTEM_ITEMS_KFV i,
586: CS_INCIDENTS_ALL_B sr,
587: CS_TRANSACTION_TYPES_B tt,

Line 634: CS_TXN_BILLING_OETXN_ALL tb,

630: p_purchase_order_num varchar2,p_txn_billing_type_id number,
631: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
632: SELECT nvl(max(edt.order_header_id),-999)
633: FROM CS_ESTIMATE_DETAILS edt,
634: CS_TXN_BILLING_OETXN_ALL tb,
635: OE_ORDER_HEADERS_ALL oe
636: WHERE edt.incident_id = p_incident_id AND
637: edt.currency_code = p_currency_code AND
638: nvl(edt.invoice_to_org_id,-999) = nvl(p_invoice_to_org_id,-999) AND