DBA Data[Home] [Help]

APPS.CSICUMPI_PUB SQL Statements

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

Line: 8

     SELECT hzpty.party_name
	FROM   hz_cust_accounts hzacct,
		  hz_cust_account_roles hzrole,
		  hz_parties hzpty
     WHERE  hzacct.account_number = l_account_number
	AND    hzrole.cust_account_id = hzacct.cust_account_id
	AND    hzpty.party_id = hzrole.party_id;
Line: 57

 SELECT CIR.OBJECT_ID
 FROM CSI_II_RELATIONSHIPS CIR
 START WITH Object_Id = P_Object_ID
 CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
 ORDER BY OBJECT_ID;
Line: 63

 SELECT CII.INSTANCE_NUMBER REFERENCE,
        CII.SERIAL_NUMBER SERIAL,
        CII.LOT_NUMBER LOT,
        MSIK.CONCATENATED_SEGMENTS PRODUCT,
        MSIK.DESCRIPTION DESCRIPTION
 FROM   CSI_ITEM_INSTANCES CII,
        MTL_SYSTEM_ITEMS_KFV MSIK
 WHERE  MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
 AND    CII.INSTANCE_ID = P_INSTANCE_ID
 AND    MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID;
Line: 106

 SELECT MSIK.Concatenated_Segments,
        MSIK.DESCRIPTION,
        CII.Instance_Number,
        CII.Serial_Number,
        CII.Lot_Number
 FROM  CSI_Item_Instances CII,
       MTL_SYSTEM_ITEMS_KFV MSIK
 WHERE CII.Instance_Id = P_Customer_Product_Id
 AND   CII.Inventory_Item_Id = MSIK.Inventory_Item_ID
 AND   CII.Inv_Master_Organization_Id = MSIK.Organization_Id;
Line: 150

  SELECT Subject_ID
  FROM CSI_II_RELATIONSHIPS
  WHERE OBJECT_ID = P_Customer_Product_Id
  AND  ACTIVE_END_DATE IS NULL;
Line: 187

                SELECT CII.Instance_Id,
                       CIIR.OBJECT_ID,
                       CIIR.RELATIONSHIP_TYPE_CODE,
                       CII.OWNER_PARTY_ACCOUNT_ID,
                       CII.INVENTORY_ITEM_ID,
                       CII.SERIAL_NUMBER,
                       CII.LOT_NUMBER
                FROM   CSI_ITEM_INSTANCES CII,
                       CSI_II_RELATIONSHIPS CIIR
                WHERE  CII.INSTANCE_ID = CIIR.SUBJECT_ID
                AND    l_AS_OF_DATE BETWEEN NVL(CIIR.ACTIVE_START_DATE,l_As_Of_Date-1) AND NVL(CIIR.ACTIVE_END_DATE,l_As_Of_Date+1)
                CONNECT BY PRIOR CIIR.SUBJECT_ID = CIIR.OBJECT_ID;
Line: 241

			SELECT Instance_Number,
			       serial_number
			INTO   l_reference_number,
			       l_curr_serial_number
			FROM   csi_Item_Instances
			WHERE  Instance_id = c1.customer_product_id;
Line: 248

				l_config_tbl.DELETE;
Line: 263

			SELECT Instance_Number,
			       serial_number
			INTO   l_reference_number,
			       l_curr_serial_number
			FROM   csi_Item_Instances
			WHERE  Instance_id = c1.customer_product_id;
Line: 270

			l_config_tbl.DELETE;
Line: 284

 SELECT CIR.OBJECT_ID
 FROM CSI_II_RELATIONSHIPS CIR
 START WITH Object_Id = P_Object_ID
 CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
 ORDER BY OBJECT_ID;