APPS.RCV_INTRANSIT_SV SQL Statements

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

Line: 38

		** Not sure if Inventory makes it mandatory to select one and
		** only one method as the default when creating the ship methods.
		*/

        SELECT MSM.INTRANSIT_TIME
        INTO   X_INTRANSIT_TIME
        FROM   MTL_INTERORG_SHIP_METHODS MSM
        WHERE  MSM.FROM_ORGANIZATION_ID = X_from_organization_id
        AND    MSM.TO_ORGANIZATION_ID	= X_to_organization_id
        AND    MSM.DEFAULT_FLAG=1;

Line: 79

        SELECT MSM.INTRANSIT_TIME
        INTO   X_INTRANSIT_TIME
        FROM   MTL_INTERORG_SHIP_METHODS MSM
        WHERE  MSM.FROM_ORGANIZATION_ID = X_from_organization_id
        AND    MSM.TO_ORGANIZATION_ID   = X_to_organization_id
        AND    ROWNUM=1;

Line: 127

       SELECT MAX(NVL(VENDOR_NAME, NULL))
         INTO v_Result
         FROM PO_VENDORS
        WHERE vendor_id = p_vendor_id;

Line: 134

       SELECT MAX(NVL(NAME, NULL))
         INTO v_Result
         FROM HR_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = p_org_id;