190: cia.incident_number
191: FROM cs_cost_details csd,
192: cs_estimate_details ced,
193: cs_txn_billing_types ctb,
194: cs_incidents_all_b cia
195: WHERE cia.incident_id = ced.incident_id
196: AND ced.estimate_detail_id = csd.estimate_detail_id
197: AND csd.txn_billing_type_id = ctb.txn_billing_type_id
198: AND nvl(ctb.interface_to_pa_flag,'N')='Y'
1741: null, --69 NA for service
1742: null, --70 NA for service
1743: null, --71 NA for service
1744: null, --72 NA for service
1745: null, --73 cs_incidents_all_b.project_id
1746: null, --74 cs_incidents_all_b.project_id
1747: null, --75 person_id mapped to the USER differs for SR and SD - should nto populate for SUPPLIER invoices
1748: null, --76 expenditure_org_id
1749: null, --77 NA for service
1742: null, --70 NA for service
1743: null, --71 NA for service
1744: null, --72 NA for service
1745: null, --73 cs_incidents_all_b.project_id
1746: null, --74 cs_incidents_all_b.project_id
1747: null, --75 person_id mapped to the USER differs for SR and SD - should nto populate for SUPPLIER invoices
1748: null, --76 expenditure_org_id
1749: null, --77 NA for service
1750: null, --78 Incase of SUPPLIER Invoices , person_id mapped to the USER differs for SR and SD (same as 73)