APPS.OEXBMCBK SQL Statements

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

Line: 36

	SELECT OEORD.HEADER_ID
	INTO   header_id
	FROM   MTL_SALES_ORDERS MTLSO,
	       SO_ORDER_TYPES_ALL OETYP,
	       SO_HEADERS_ALL OEORD
	WHERE  MTLSO.SALES_ORDER_ID = dem_src_header
	AND    OETYP.NAME = MTLSO.SEGMENT2
	AND    OEORD.ORDER_NUMBER = TO_NUMBER( MTLSO.SEGMENT1 )
	AND    OEORD.ORDER_TYPE_ID = OETYP.ORDER_TYPE_ID;

Line: 53

	UPDATE 	SO_LINES_ALL
	SET 	S27 = 23
	WHERE 	HEADER_ID = header_id
	AND 	(LINE_ID = dem_src_line
		 OR ATO_LINE_ID = dem_src_line)
	AND 	ATO_FLAG = 'Y';

Line: 67

	UPDATE	SO_LINES_ALL
	SET	S27 = 4
	WHERE	HEADER_ID = header_id
	AND 	(LINE_ID = dem_src_line
		 OR ATO_LINE_ID = dem_src_line)
	AND 	ATO_FLAG = 'Y'
	AND 	NOT EXISTS
		(SELECT	'Released Details'
		 FROM	SO_LINE_DETAILS
		 WHERE	LINE_ID IN
			(SELECT LINE_ID
			 FROM SO_LINES_ALL
			 WHERE LINE_ID = dem_src_line)
		 AND 	INVENTORY_ITEM_ID = config_item_id
		 AND 	RELEASED_FLAG = 'Y');

Line: 92

	SELECT 	SO_DELIVERIES_S.NEXTVAL
	INTO 	dem_src_delivery
	FROM 	DUAL;

Line: 105

	INSERT INTO SO_LINE_DETAILS
		(LINE_ID,
                 LINE_DETAIL_ID,
                 DELIVERY,
                 CREATED_BY,
                 CREATION_DATE,
                 LAST_UPDATED_BY,
                 LAST_UPDATE_DATE,
                 COMPONENT_CODE,
                 COMPONENT_RATIO,
                 COMPONENT_SEQUENCE_ID,
                 CONFIGURATION_ITEM_FLAG,
                 CUSTOMER_REQUESTED_LOT_FLAG,
                 DEMAND_CLASS_CODE,
                 INCLUDED_ITEM_FLAG,
                 INVENTORY_ITEM_ID,
                 INVENTORY_LOCATION_ID,
                 LATEST_ACCEPTABLE_DATE,
                 LOT_NUMBER,
                 QUANTITY,
                 RELEASED_FLAG,
                 REQUIRED_FOR_REVENUE_FLAG,
                 SHIPPABLE_FLAG,
                 TRANSACTABLE_FLAG,
                 RESERVABLE_FLAG,
                 REVISION,
                 SCHEDULE_DATE,
                 SCHEDULE_STATUS_CODE,
                 SUBINVENTORY,
                 UNIT_CODE,
                 WAREHOUSE_ID,
                 CUSTOMER_ITEM_ID,
                 DPW_ASSIGNED_FLAG,
                 WIP_COMPLETED_QUANTITY,
                 WIP_RESERVED_QUANTITY,
                 CONTEXT,
                 ATTRIBUTE1,
                 ATTRIBUTE2,
                 ATTRIBUTE3,
                 ATTRIBUTE4,
                 ATTRIBUTE5,
                 ATTRIBUTE6,
                 ATTRIBUTE7,
                 ATTRIBUTE8,
                 ATTRIBUTE9,
                 ATTRIBUTE10,
                 ATTRIBUTE11,
                 ATTRIBUTE12,
                 ATTRIBUTE13,
                 ATTRIBUTE14,
                 ATTRIBUTE15)
        SELECT   LD.LINE_ID,
                 SO_LINE_DETAILS_S.NEXTVAL,
                 dem_src_delivery,
                 user_id,
                 SYSDATE,
                 user_id,
                 SYSDATE,
                 NVL(LD.COMPONENT_CODE, LD.INVENTORY_ITEM_ID)
			|| '-' || TO_CHAR(config_item_id),
                 LD.COMPONENT_RATIO,
                 NULL,
                 'Y',
                 LD.CUSTOMER_REQUESTED_LOT_FLAG,
                 LD.DEMAND_CLASS_CODE,
                 'N',
                 config_item_id,
                 LD.INVENTORY_LOCATION_ID,
                 LD.LATEST_ACCEPTABLE_DATE,
                 LD.LOT_NUMBER,
                 LD.QUANTITY,
                 'N',
                 LD.REQUIRED_FOR_REVENUE_FLAG,
                 'Y',
                 'Y',
                 'Y',
                 LD.REVISION,
                 LD.SCHEDULE_DATE,
                 LD.SCHEDULE_STATUS_CODE,
                 LD.SUBINVENTORY,
                 LD.UNIT_CODE,
                 LD.WAREHOUSE_ID,
                 LD.CUSTOMER_ITEM_ID,
                 LD.DPW_ASSIGNED_FLAG,
                 NULL,
                 NULL,
                 LD.CONTEXT,
                 LD.ATTRIBUTE1,
                 LD.ATTRIBUTE2,
                 LD.ATTRIBUTE3,
                 LD.ATTRIBUTE4,
                 LD.ATTRIBUTE5,
                 LD.ATTRIBUTE6,
                 LD.ATTRIBUTE7,
                 LD.ATTRIBUTE8,
                 LD.ATTRIBUTE9,
                 LD.ATTRIBUTE10,
                 LD.ATTRIBUTE11,
                 LD.ATTRIBUTE12,
                 LD.ATTRIBUTE13,
                 LD.ATTRIBUTE14,
                 LD.ATTRIBUTE15
	FROM 	SO_LINE_DETAILS LD
	WHERE 	LD.LINE_ID = dem_src_line
	AND 	LD.INCLUDED_ITEM_FLAG = 'N'
	AND 	ROWNUM = 1;

Line: 219

	DELETE 	FROM 	SO_LINE_DETAILS
		WHERE 	LINE_ID = dem_src_line
		AND 	INVENTORY_ITEM_ID = config_item_id;