APPS.PA_INV_ON_ACCOUNT_CM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	SELECT	pdi_cm.project_id,
		pdi_cm.draft_invoice_num,
		ra.interface_line_attribute1,
		ra.interface_line_attribute2,
		ra.batch_source_name,
		pdi.system_reference,
		NVL(rbs.gen_line_level_bal_flag,'N') line_level_bal_flag,
		sum(pdii_cm.inv_amount) cm_amount,
		rctt.allow_overapplication_flag
	FROM	ra_interface_lines	ra,
		pa_draft_invoices	pdi,
		pa_draft_invoices	pdi_cm,
		pa_implementations	pi,
		pa_projects		pa,
		ra_batch_sources	rbs,
		pa_draft_invoice_items	pdii_cm,
		ra_customer_trx         rct,
		ra_cust_trx_types       rctt
	WHERE	pdi_cm.project_id = pdi.project_id
	AND	pdi_cm.draft_invoice_num_credited = pdi.draft_invoice_num
	AND	pdi_cm.project_id = pa.project_id
	AND	rbs.batch_source_id = pi.invoice_batch_source_id
	AND	rbs.name = ra.batch_source_name
	AND	pdi_cm.request_id = p_request_id
	AND	pdi_cm.project_id = p_project_id
	AND	SUBSTR(pa.segment1,1,25) = ra.interface_line_attribute1
	AND	TO_CHAR(pdi_cm.draft_invoice_num) = ra.interface_line_attribute2
	AND	pdii_cm.project_id = pdi_cm.project_id
	AND	pdii_cm.draft_invoice_num = pdi_cm.draft_invoice_num
	AND	pdi.system_reference = rct.customer_trx_id
	AND	rct.cust_trx_type_id = rctt.cust_trx_type_id
	GROUP BY pdi_cm.project_id,
		pdi_cm.draft_invoice_num,
		ra.interface_line_attribute1,
		ra.interface_line_attribute2,
		ra.batch_source_name,
		pdi.system_reference,
		NVL(rbs.gen_line_level_bal_flag,'N'),
		rctt.allow_overapplication_flag;

Line: 56

	SELECT	pdii.project_id,
		pdii.line_num,
		pdii.draft_inv_line_num_credited line_num_credited,
		pdii.inv_amount
	FROM	pa_draft_invoice_items pdii
	WHERE	pdii.project_id = c_project_id
	AND	pdii.draft_invoice_num = c_draft_invoice_num
	AND	inv_amount <> 0 ;

Line: 69

	SELECT	NVL(create_on_account_cm,'N')
	INTO	l_create_on_account_cm
	FROM	pa_implementations;

Line: 103

					UPDATE	ra_interface_lines ra
					SET	Reference_Line_Attribute1 = NULL,
						Reference_Line_Attribute2 = NULL,
						Reference_Line_Attribute3 = NULL,
						Reference_Line_Attribute4 = NULL,
						Reference_Line_Attribute5 = NULL,
						Reference_Line_Attribute6 = NULL,
						Reference_Line_Attribute7 = NULL,
						Reference_Line_Attribute8 = NULL,
						Reference_Line_Context = NULL
					WHERE	ra.batch_source_name = c_cm_rec.batch_source_name
					AND	ra.interface_line_attribute1 = c_cm_rec.interface_line_attribute1
					AND	ra.interface_line_attribute2 = c_cm_rec.interface_line_attribute2;

Line: 146

						UPDATE	ra_interface_lines ra
						SET     Reference_Line_Attribute1 = NULL,
							Reference_Line_Attribute2 = NULL,
							Reference_Line_Attribute3 = NULL,
							Reference_Line_Attribute4 = NULL,
							Reference_Line_Attribute5 = NULL,
							Reference_Line_Attribute6 = NULL,
							Reference_Line_Attribute7 = NULL,
							Reference_Line_Attribute8 = NULL,
							Reference_Line_Context = NULL
						WHERE	ra.batch_source_name = c_cm_rec.batch_source_name
						AND	ra.interface_line_attribute1 = c_cm_rec.interface_line_attribute1
						AND	ra.interface_line_attribute2 = c_cm_rec.interface_line_attribute2;