DBA Data[Home] [Help]

APPS.GML_OPM_PO SQL Statements

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

Line: 9

		SELECT count(*) into v_result
		FROM cpg_oragems_mapping
		WHERE po_header_id = p_po_header_id;
Line: 29

     SELECT segment1
     FROM   mtl_system_items_b
     WHERE  inventory_item_id = p_inventory_item_id AND
	    organization_id = p_organization_id;